Here is a short list of other common possible permissions that users can enjoy.
To provide a specific user with a permission, you can use this framework:
GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’; e.g. GRANT ALL PRIVILEGES ON test_db .* TO 'test-db-user'@'localhost';
If you want to give them access to any database or to any table, make sure to put an asterisk (*) in the place of the database name or table name.
Each time you update or change a permission be sure to use the Flush Privileges command.
FLUSH PRIVILEGES; If you need to revoke a permission, the structure is almost identical to granting it:
REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;
Just as you can delete databases with DROP, you can use DROP to delete a user altogether:
DROP USER ‘’@‘localhost’;
To test out your new user, log out by typing
and log back in with this command in terminal:
mysql -u [username]-p