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 on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store