mysql 报错 The MySQL server is run
2018-11-09 本文已影响0人
小手冰冰凉啊
在对mysql数据库进行操作的时候，报了如下错误
mysql> set password for root@localhost = password('123456');
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.00 sec)
mysql> set password for root@localhost = password('123456');
Query OK, 0 rows affected, 1 warning (0.00 sec)
