Mysql报错：ERROR 1290 (HY000)

作者: 小渣渣努力中 | 来源:发表于2020-11-13 16:03 被阅读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

Mysql报错：ERROR 1290 (HY000)
执行：报错：ERROR 1290 (HY000): The MySQL server is running wi...
Mysql 常见报错
1. 导出文件报错 ERROR 1290 (HY000): The MySQL server is running...
ERROR 1290 (HY000)
ERROR 1290 (HY000): The MySQL server is running with the ...
2019-11-16 MySQL 导出特定的文件夹
MySQL】ERROR 1290 (HY000): The MySQL server is running wit...
Ubuntu18.04 ERROR 1290 (HY000):
在ubuntu18.04中运行mysql导出和输入文件发现报错：ERROR 1290 (HY000): The M...
MySQL报错：mysql：ERROR 1819 (HY000)
MySQL报错：mysql：ERROR 1819 (HY000): Your password does not ...
【MySQL基础】MySQL错误记录
1、MySQL 8.0.12 报错ERROR 1215 (HY000): Cannot add foreign k...
mysql配置问题:writing one row to the
mysql数据库插表报错在mysql导入数据时，报错信息如下： error 1534 (HY000): wri...
2019-05-22
mac下面mysql连接报错ERROR 2002 (HY000): Can't connect to local ...
mysql-创建用户报错ERROR 1396 (HY000):
mysql-创建用户报错ERROR 1396 (HY000): Operation CREATE USER fai...