mysql 报错ERROR 1290 (HY000):
来源:互联网 发布:java中的各种模式 编辑:程序博客网 时间:2024/06/05 09:40
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statemen
mysql 配置文件目录:/etc/my.cnf
root 密码为空的时候配置文件中下面这句:
skip-grant-tables
GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY '123' WITH GRANT OPTION;
执行这句时候错误:
ERROR 1290 (HY000): The MySQL server
is
running with the --skip-grant-tables option so it cannot execute
this
statement
mysql> GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY
'123'
WITH GRANT OPTION;
ERROR 1290 (HY000): The MySQL server
is
running with the --skip-grant-tables option so it cannot execute
this
statement
这个时候我们只需要
flush privileges
一下,在添加用户就OK了,
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY '123' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
这个时候我们成功搞定了,再登录就可以了。
如果报错如下信息:
Error: Cannot retrieve repository metadata (repomd.xml) for repository: InstallMedia. Please verify its path and try again
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
我们只要到/etc/yum.repo.s下面把packetxxxx.repo和redhat.repo两个文件删除掉,再启动就可以了,
0 0
- mysql 报错ERROR 1290 (HY000):
- MySQL 启动报错-ERROR 2002 (HY000)
- mysql ERROR 1290 (HY000):
- MySQL 启动slave报错 ERROR 1201 (HY000)
- ERROR 1449 (HY000)--Mysql查询视图报错
- 解决MySql 报错:ERROR 1366 (HY000): Incorrect string value....
- 解决Linux MySQL报错ERROR 2002 (HY000)
- mysql命令行进入报错ERROR 2002 (HY000)
- ubuntu 下Mysql导入导出文件报错:ERROR 1290 (HY000): --secure-file-priv
- MySQL 报错 ERROR 1290 (HY000): running with the --secure-file-priv
- MYSQL删除数据库报 ERROR 1010 (HY000): Error dropping database
- Mysql启动报错:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- mysql升级报错:ERROR 2013 (HY000): Lost connection to MySQL server during query
- MySQl UDF加载报错(ERROR 1124 (HY000): No paths allowed for shared library)
- mysql只能连自己(报错:ERROR 1130 (HY000): Host)
- MySQL报错ERROR 1615 (HY000): Prepared statement needs to be re-prepared
- java调用mysql数据库存储过程报错ERROR 1615 (HY000)问题的解决方法(之一)
- mysql-创建用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'XXXX'@'XXXX'
- 日期计算相关
- DBA 分布式数据库复习总结
- 浅谈友链、权重网站背后的秘密。。
- 不用算术运算符实现两个数的加法(按位异或)
- 数据结构
- mysql 报错ERROR 1290 (HY000):
- 优化UITableViewCell高度计算的那些事
- 提高效率的 Android Studio快捷键 技巧汇总
- 26. Remove Duplicates from Sorted Array&&27. Remove Element
- Kafka在Zookeeper中保存数据的结构
- [Python]第十讲:迭代
- 直播方向的资源收集
- soot代码分析框架的基础知识(一)
- Hadoop MapReduce 程序执行过程