ERROR 1269 (HY000): Can't revoke all privileges for one or more of the requested users

mysql> revoke all privileges,grant option from 'testuser';
ERROR 1269 (HY000): Can't revoke all privileges for one or more of the requested users

出错原因：

Before MySQL 4.1.2, all privileges cannot be dropped at once. Two statements are necessary: 

REVOKE ALL PRIVILEGES ON *.* FROM user [, user] ...
REVOKE GRANT OPTION ON *.* FROM user [, user] ...

mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'testuser';

ERROR 1269 (HY000): Can't revoke all privileges for one or more of the requested users

mysql> REVOKE ALL PRIVILEGES ON *.* FROM 'testuser'@'localhost';

Query OK, 0 rows affected (0.02 sec)


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