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

本文主要是介绍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)

这篇关于ERROR 1269 (HY000): Can't revoke all privileges for one or more of the requested users的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---