ERROR 1290 (HY000)

2018-08-21  本文已影响0人  帕博雷克斯丢丢

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)
上一篇下一篇

猜你喜欢

热点阅读