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