【MySQL】The MySQL server is running with the --skip-grant-tables option so it cannot execute this ...

问题描述:

新建数据库用户:

1
create user test identified by 'password';

然后便报错:

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

解决方法:

刷新权限表

1
flush privileges;

再重新新建用户即可。