How to create a New Database-user and Grand Permissions – MySQL

Linux, MySQL / March 22, 2021 / ashishpsk / 0

Enter the mysql prompt by following the step below:

# mysql -u root -p

It then prompts for password. Enter the MySQL root password.

root@server [/]# mysql -u root -p
Enter password:

Command to Grand All privileges on DB for a user.

mysql> GRANT ALL PRIVILEGES ON database.* to 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

how to add SELECT privileges to a user using GRANT.

mysql> GRANT SELECT ON database.* to 'username'@'localhost' IDENTIFIED BY 'password';

how to add a selection of privileges to a user using GRANT.

mysql> GRANT SELECT, INSERT, DELETE ON database.* to 'username'@'localhost' IDENTIFIED BY 'password';

Latest posts

In your terminal, login as the postgres user (for security reasons, the postgres user has no password. That’s...

openssl ciphers -v | awk '{print $2}' | sort | uniq

For TLS 1.3:

openssl s_client...

Mass suspend or unsuspend mailboxes of a domain

Using the API, can help you quickly...

To Disable Strict Mode via SQL

mysql -u root -p -e "SET GLOBAL sql_mode =...

Using visudo, add the following to your sudoers file, replacing username with the proper...

MySQL SHOW USERS: List All Users in a MySQL Database Server:

>mysql -u root -p
Enter...