SYSbible

A bible next to an old computer.

Revoking MySQL Permissions

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

Posted

in

,

by

unai

Tags:

,

Comments

0 responses to “Revoking MySQL Permissions”

  1. brent Avatar
    brent

    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

  2. unai Avatar
    unai

    Dear Brent,

    Thank you for your comment.

    What do you mean?

    With Best Wishes,
    unai