Mysql - Grand permission for a mysql user, How to fix Access Denied for mysql user

Grand permission for a mysql user

If you get a permission error while accessing MySQL Database? Use the following sql command to fix privilege issues.

  
 # GRANT ALL ON database_name TO 'user_name'@'localhost';

 # FLUSH PRIVILEGES;

First you have to provide access for a user to specific database once you have made permission changes, it's good to reload all the privileges with the flush command.

The topic on Mysql - Grand permission for a mysql user is posted by - Guru

Hope you have enjoyed, Mysql - Grand permission for a mysql userThanks for your time