Granting Access Privileges to Users in MySQL

mysql> GRANT ALL ON data.* TO root_bk@localhost;

mysql> GRANT SELECT, INSERT, UPDATE ON data.* TO nicole@localhost;

mysql> SHOW GRANTS FOR root_bk@localhost

This is the second step granting access rights to everything on the database called “data” to the backup root account and only granting partial rights to the regular user

Specify the rights being granted

Specify the Database

Specify the User

You can verify the rights are set correctly with this command