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.

Syntax:

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

Example: 
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