How to Create a MySQL User and Grant Privileges (Step-by-Step)

You can grant multiple privileges in one command by separating them with commas: eg: “GRANT UPDATE, SELECT ON [database name].[table name] TO ‘[username]’@‘localhost’;”

This code from above has a backtick before localhost. It should be a single quote.

GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@‘localhost’;

Updated

Hi, nice intro. It was useful. I noticed that for the REVOKE command, one has to use FROM, not TO. Also, might be helpful for new users to know that they can use ‘%’ as a wildcard instead of ‘localhost’.

This worked for me. However to be able to use MySql Workbench it seems it wants another version of the user. I needed to do the following (which has taken me a few hours of playing around with to get right) mysql> select user,host from mysql.user; <–to see users mysql> GRANT ALL ON . to user@’%’ IDENTIFIED BY ‘user-pwd’; mysql> FLUSH PRIVILEGES; mysql> select user,host from mysql.user; mysql>quit Also need to comment out or change the bind-address to <droplet address>. This does reduce security. sudo nano /etc/mysql/my.cnf ;bind-address=127.0.0.1 exit and $service mysql start $service mysql stop

then get access on <droplet-ip> from my Sql workbench using user/user-pwd on std port for adminstering, creating and querying.

There’s no link at the start of this tutorial to the first tutorial. Can you please add that link?

useful

how to give permission to only select views in requried user pls send me urgent

@ravuri.srinivasarao7: Please read the second part of the article: “How To Grant Different User Permissions”

Is there a way to just give permission to create a new table within the specified database, but not allow the creation of a new database?