mysql -e "REVOKE ALL PRIVILEGES ON mydb.* FROM 'alice'@'localhost';"
Remove a user's privileges on a database
The counterpart to GRANT; takes effect immediately without FLUSH PRIVILEGES. Verify with SHOW GRANTS FOR 'alice'@'localhost'. Related: DROP USER removes the account entirely.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.