REVOKE
CautionRevoke privileges
REVOKE <priv> ON db.table FROM 'user'@'host';
Removes grants — for offboarding and tightening. Check SHOW GRANTS before and after.
Examples
REVOKE DELETE ON app.* FROM 'webapp'@'%';Strip a risky privilege
Syntax
REVOKE <privs> ON <db.obj> FROM 'user'@'host';
Before you run it
Don't break the app's required privileges.
Related commands
- GRANTGrant privileges
- SHOW GRANTSShow grants
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store