Revoking MySQL Permissions

Usage:

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

1 2	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)

1 2	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)

1 2	mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)

See Also

2 thoughts on “Revoking MySQL Permissions”

hi, brother.
I have readed your post about haproxy-mysql. it’s good for me ..

many thanks for your sharing .

but ,I have a question about mysql Data validation without locking tables.
I didn’t find a tool could do this without locking tables

could you tell me how could I check the data?

this si my email address
brentch@163.com

Dear Brent,

Thank you for your comment.

What do you mean?

With Best Wishes,
unai

A paradise for Sysads. Hosted on Leanservers.