How To Create a New User and Grant Permissions in MySQL8

create-mysql-user-grant-permission.md

How To Create a New User and Grant Permissions in MySQL 8

Use the grant permissions command.

If your database name is "newdb" and user is "newuser" the command to grant all privileges on all the tables contained within would be:

Create A New User

mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
#if user needs to grant access from the remote machine
mysql> CREATE USER 'newuser'@'8.8.8.8' IDENTIFIED BY 'password';

Grant Privileges

mysql> GRANT ALL PRIVILEGES ON newdb.* TO 'newuser'@'localhost';
#if selective permissions need to grant
mysql> GRANT SELECT, INSERT, DELETE ON newdb.* TO newuser@'localhost';

Show Granted Privileges

mysql> SHOW GRANTS FOR 'newuser'@'localhost';

Refresh Privileges

mysql> FLUSH PRIVILEGES;

Drop User

mysql> DROP USER 'newuser'@'localhost';