MySQL报错:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

报错问题:

 

 解决办法

1.刷新权限

mysql> flush privileges;

 

 

2.给root用户所有权限

mysql> grant all on cactidb.* to root@'localhost' identified by '123';

 

 

3.退出mysql环境

mysql> exit

 

4.重新登录便可