ERROR 1227 (42000)

admin

1.drop user 报错

1. mysql> drop user 'root'@'vm2';
   
2. ERROR 1227 (42000): Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
   
3. mysql> grant system_user on *.* to root;
   
4. Query OK, 0 rows affected (0.01 sec)
   

复制代码

2.原因是由于root用户没有SYSTEM_USER权限，把权限加入后即可解决

1. mysql> grant system_user on *.* to root;
   
2. Query OK, 0 rows affected (0.01 sec)
   
3. 
   
4. mysql> flush privileges;
   
5. Query OK, 0 rows affected (0.01 sec)
   
6. 
   
7. mysql> drop user 'root'@'vm2';
   
8. Query OK, 0 rows affected (0.01 sec)
   

复制代码