Khandaker Toihidul Islam
Software Engineer
Backend : PHP | Mysql | Symfony | CakePhp | Wordpress | Drupal
Frontend : Node js | Vue js | React Js | Javascript | HTML | CSS | Bootstrap
Tools , Server : Nginx | Apache | Git | Jenkins | Jira | Asana | Silenium | Spira

How To Create a New User and Grant Permissions in MySQL

  1. Login to mysql
mysql -u username -p

2. Create user

REATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

3. Set permission

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

4. Permission for a specific database

GRANT ALL PRIVILEGES ON `databasename`.* TO 'username'@'localhost' WITH GRANT OPTION;

5. Rerfresh

FLUSH PRIVILEGES;

How To Grant Different User Permissions

Here is a short list of other common possible permissions that users can enjoy.

  • ALL PRIVILEGES- as we saw previously, this would allow a MySQL user full access to a designated database (or if no database is selected, global access across the system)
  • CREATE- allows them to create new tables or databases
  • DROP- allows them to them to delete tables or databases
  • DELETE- allows them to delete rows from tables
  • INSERT- allows them to insert rows into tables
  • SELECT- allows them to use the SELECT command to read through databases
  • UPDATE- allow them to update table rows
  • GRANT OPTION- allows them to grant or remove other users’ privileges

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *