How to Revoke Permissions for user in MySQL server - MySQL DBA Tutorial

How to Revoke Permissions for user/login in MySQL Server 

To Revoke permissions of a user account in MySQL Server, below syntax can be used.


MySQL > REVOKE PermissionType ON Object To 'UserName'@'Host';

Let's say we have user TB and we have provided Delete Permission on all the Tables in TechBrothers Database and we would like to Revoke.We can use below statement.

MySQL > REVOKE DELETE ON TechBrothers.* FROM 'TB'@'localhost';

MySQL Training for beginners - How to remove permission for MySQL user