*mysql> create user 'test'@'localhost' identified by 'pass';*
Query OK, 0 rows affected (0.00 sec)
*mysql> GRANT CREATE, DELETE ON *.* TO 'test'@'localhost';*
Query OK, 0 rows affected (0.00 sec)
*mysql> select * from information_schema.user_privileges where grantee like
"'test'@'localhost'";*
+--------------------+---------------+----------------+--------------+
| GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+--------------------+---------------+----------------+--------------+
| 'test'@'localhost' | NULL | DELETE | NO |
| 'test'@'localhost' | NULL | CREATE | NO |
+--------------------+---------------+----------------+--------------+
2 rows in set (0.00 sec)
*mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'test'@'localhost';*
Query OK, 0 rows affected (0.00 sec)
*mysql> select * from information_schema.user_privileges where grantee like
"'test'@'localhost'";*
+--------------------+---------------+----------------+--------------+
| GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+--------------------+---------------+----------------+--------------+
| 'test'@'localhost' | NULL | USAGE | NO |
+--------------------+---------------+----------------+--------------+
*
<http://dev.mysql.com/doc/refman/5.0/en/revoke.html>REVOKE<http://dev.mysql.com/doc/refman/5.0/en/revoke.html>removes
privileges, but does not drop
mysql.user table entries. To remove a user account entirely, use DROP
USER<http://dev.mysql.com/doc/refman/5.0/en/drop-user.html>
mysql> drop user 'test'@'localhost;
mysql> select * from information_schema.user_privileges where grantee like
"'test'@'localhost'";
Empty set (0.00 sec)
*
