MySQL: Revoke Permissions

• Replace {db} with the name of the database.
• Replace {user} with the name of the user.

Revoke Permissions

REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%';

Example: Revoke all privileges on database web from user andunix.

REVOKE ALL PRIVILEGES ON `web` . * FROM 'andunix'@'%';