change database privileges mysql code example
Example: mysql update privileges
mysql> REVOKE ALL ON example_database.* FROM 'user_name'@'host_name';
mysql> GRANT privilege1, privilege2 ON example_database.* TO 'user_name'@'host_name';
mysql> REVOKE ALL ON example_database.* FROM 'user_name'@'host_name';
mysql> GRANT privilege1, privilege2 ON example_database.* TO 'user_name'@'host_name';