ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement.
1:
事件复盘:
之前在mysql中创建了一个库aa@localhost
,在删除的时候报错:
mysql> drop user aa@localhost;
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables
option so it cannot execute this statement
解决:
在删除用户前刷新一下权限;
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql> drop user aa@localhost;
Query OK, 0 rows affected (0.00 sec)
网友评论