Grant Permissions to a MySQL User Via Command - Fix Access Denied for User

by Dinesh 2014-06-23 11:42:47

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';
When finished making your permission changes, it’s good to reload all the privileges with the flush command!
FLUSH PRIVILEGES;



 

Tagged in:

1194
like
0
dislike
0
mail
flag

You must LOGIN to add comments