mysql8出现The MySQL server is running with the --skip-grant-tables option so it cannot execute

执行以下语句的时候

mysql> CREATE USER 'appleyuchi'@'%' IDENTIFIED with mysql_native_password  BY 'appleyuchi';
出现:

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

解决方案:

先执行

mysql> flush privileges;

然后再

mysql> CREATE USER 'appleyuchi'@'%' IDENTIFIED with mysql_native_password  BY 'appleyuchi';

即可

总结

以上是生活随笔为你收集整理的mysql8出现The MySQL server is running with the --skip-grant-tables option so it cannot execute的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。