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

问题描述：

新建数据库用户：

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”

解决方法：

刷新权限表

flush privileges;

再重新新建用户即可。