How to change MySql privileges for users

To find out the permissions that users have on MySql server

select * from mysql.user
where host like 'X.X.X.X'

To Update the privileges

update mysql.user
set Select_priv = 'Y', Insert_priv='Y',Update_priv='Y'
where host like 'X.X.X.X';

flush privileges;

Don’t forget to flush the privileges, it just clears out the cache of MySql privileges.

Complete list of privileges for MySql users:
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html

Leave a Reply

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