Mysql报错:ERROR 1290 (HY000)

2020-11-13  本文已影响0人  小渣渣努力中

执行:

CREATE USER 'username'@'localhost' 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;

再次执行:

> CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

提示成功


image.png
上一篇 下一篇

猜你喜欢

热点阅读