Revoking MySQL Permissions

Posted on by

Usage:

mysql> revoke PRIVILEGES [, GRANT OPTION] from 'USERNAME'@'SERVER';
mysql> flush privileges;

Example:

mysql> revoke all privileges, grant option from 'comsiteuatusr'@'10.135.7.114';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

See Also