ERROR 1227 (42000)
1.drop user 报错mysql> drop user 'root'@'vm2';
ERROR 1227 (42000): Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
mysql> grant system_user on *.* to root;
Query OK, 0 rows affected (0.01 sec)
2.原因是由于root用户没有SYSTEM_USER权限,把权限加入后即可解决
mysql> grant system_user on *.* to root;
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> drop user 'root'@'vm2';
Query OK, 0 rows affected (0.01 sec)
页:
[1]