ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statemen
2024-10-15 18:40:54
转自:http://www.cnblogs.com/iosdev/archive/2013/07/15/3190431.html
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两个文件删除掉,再启动就可以了,
最新文章
- [DFNews] Cellebrite UFED Logical/Physical Analyzer 3.8.1 维护性更新
- NOIP201307货车运输
- PHP : Reflection API
- C++_Eigen函数库用法笔记——Block Operations
- JAVA String作业——动手动脑以及课后实验性问题
- Delphi的Socket编程步骤(repulish)
- 关于报错The specified child already has a parent的解决办法
- 数字图象处理MATLAB学习
- oracle----修改表中的数据
- Java- Jdbc学习
- ffmpeg与RTMP流媒体连接用法(翻译) http://www.chinavideo.org/forum.php?mod=viewthread&;tid=15423
- SAS SATA SSD基本介绍
- [ZJOI2011]营救皮卡丘
- XBee 802.15.4/Digimesh FAQs:如何为2.4G模块选择合适的信道
- 百度地图开发者API学习笔记二
- [HDFS Manual] CH2 HDFS Users Guide
- 通过 JDK 自带的 javap 命令查看 SynchronizedDemo 类的相关字节码信息
- linux百万并发之 tcp_mem
- C语言和python的区别
- [转]shell脚本每行的执行顺序是怎样