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)

MySQL Revoke User