GMgKe586q6suSQnyqZLlGCooeWM

Pages

Search

Thursday, December 23, 2010

MySQL Revoke User

With REVOKE statement, you hope that some grants will be removed.

mysql> REVOKE insert ON *.* FROM 'luna'@'localhost';
Query OK, 0 rows affected (0.02 sec)

mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'luna'@'localhost';
Query OK, 0 rows affected (0.02 sec)
Share/Bookmark

No comments:

Post a Comment