I Cannot REVOKE GRANT.
I sow GRANT and REVOKE syntax.
GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY 'password']
[, user_name [IDENTIFIED BY 'password'] ...] [WITH GRANT OPTION]
mysql> grant usage on *.* to xxx@localhost width grant option;
TESTINT OK !!
REVOKE priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*} FROM user_name [, user_name ...]
mysql> revoke usage on *.* from xxx@localhost width grant option;
TESTINT NG !!
The person who had the same trouble as me was here.
--- MySQL Bugs: #2642: Error in REVOKE grammar ---
http://bugs.mysql.com/bug.php?id=2642
Please help.