mysql> REVOKE ALL ON example_database.* FROM 'user_name'@'host_name'; mysql> GRANT privilege1, privilege2 ON example_database.* TO 'user_name'@'host_name';