MySQL - Delete privileges of a user

Revision as of 18:43, 14 April 2020 by Ardaut (talk | changes)

Use the same privileges string as it is displayed in the output of the command "show grants for 'myuser'@'localhost';"

Delete (revoke) all privileges of a user:
REVOKE ALL PRIVILEGES ON mytable.* FROM 'myuser'@'localhost';
Delete (revoke) a certain privilege of a user:
REVOKE DELETE ON mytable.* FROM 'myuser'@'localhost';
Delete (revoke) certain privilges of a user:
REVOKE DELETE, SELECT ON mytable.* FROM 'myuser'@'localhost';

ALTERNATIVE: Delete the user and add him then again

drop user [email protected];

More info: