Linux MySQL常见问题小结 FAQ
来源:互联网 发布:网络劫持 编辑:程序博客网 时间:2024/06/11 03:04
本文转自大神 TS_A1 博客地址:http://my.csdn.net/typa01_kk 。
问题1:
[root@Tony_ts_tian bin]# mysqladmin -uroot password 'kaka123'
mysqladmin: connect to server at 'localhost' failed
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)'
[root@Tony_ts_tian bin]# MySQL
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@Tony_ts_tian bin]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost'(using password: YES)
问题1.1:
发现mysql数据库下user表中,Host和User为两个主键列。
mysql> update user set host='%' where user='root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
解决1 (7:忘记密码):
注:--skip-grant-tables 启动mysql时不启动grant-tables,授权表
--skip-networking关闭MySQL的TCP/IP连接方式,跳过网络
注:不要关闭上个终端,再次打开一个终端。
执行以下指令:
或者:
注:也可使用:/etc/mysql/debian.cnf文件中[client]下配置的密码。
问题2:
mysql> use mysql
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
解决2:
修改后继续使用。
问题3:
mysql> INSERT INTO mysql.user(Host,User,Password) VALUES("10.155.123.55","kaka",PASSWORD("kaka123"));
ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
mysql> INSERT INTO mysql.user(Host,User,Password,ssl_cipher) VALUES("10.155.123.55","kaka",PASSWORD("kaka123"),"");
ERROR 1364 (HY000): Field 'x509_issuer' doesn't have a default value
mysql> INSERT INTO mysql.user(Host,User,Password,ssl_cipher,x509_issuer) VALUES("10.155.123.55","kaka",PASSWORD("kaka123"),"","");
ERROR 1364 (HY000): Field 'x509_subject' doesn't have a default value
mysql> INSERT INTO mysql.user(Host,User,Password,ssl_cipher,x509_issuer) VALUES("10.155.123.55","kaka",PASSWORD("kaka123"),"","");
ERROR 1364 (HY000): Field 'x509_subject' doesn't have a default value
解决3:
问题4:
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'weloveshare'
解决4:
问题5:
C compiler on this system is: cc
Cannot find appropriate C++ compiler on this system.
configure: error: no acceptable C compiler found in $PATH
解决5:
问题6:configure: error: no acceptable m4 could be found in $PATH.
解决6:
问题7:make[1]: *** [sql/CMakeFiles/sql.dir/all] Error 2
ubuntu version: Ubuntu 14.04 LTS
解决7:
1:要么磁盘存储空间不足,一版5.6的大概30G左右!
2:安装:
问题8:
make && make install
The program 'make' is currently not installed. You can install it by typing:
解决8:
问题9:mysql启动失败!
root@server:/usr/local/mysql/support-files# ./mysql.server start
Starting MySQL
... * The server quit without updating PID file (/data/mysql.pid).
解决9:
1:my.cnf 配置文件配置错误!参考!
2:安装完后,可能重启下系统,可选建议!
3:mysql源码编译问题!
- Linux MySQL常见问题小结 FAQ
- linux常见问题FAQ
- Linux常见问题(FAQ)
- Linux内核/模块开发常见问题集(FAQ)
- Linux内核/模块开发常见问题集(FAQ)
- Linux内核/模块开发常见问题集(FAQ)
- Linux内核/模块开发常见问题集(FAQ)
- linux配置mysql常见问题
- RPM软件包使用常见问题 ----------- { rpm 使用 答疑 FAQ (Linux) }
- Linux下Jboss启动、关闭、端口配置等常见问题FAQ
- linux rhel6.2 intel dpdk FAQ 常见问题和解决办法
- MySQL无法启动几种常见问题小结
- minij2ee常见问题(FAQ)
- Solaris常见问题解答 (FAQ)
- MP3常见问题FAQ
- JBuilderX 常见问题FAQ
- DWF常见问题faq
- WAP常见问题FAQ
- Android Wear书签
- 信号---信号的产生
- 第22节:Scala集合和高级函数操作
- linux中nginx配置https
- 训练营结业作业
- Linux MySQL常见问题小结 FAQ
- pip初相识
- LeetCode 107. Binary Tree Level Order Traversal II
- 字符串转换成数字的方法【C#】
- 如何修复损坏的MySQL数据表
- Linux内核分析(九)——总结篇
- 10 条提升 Android 性能的建议
- Swift字符串的基本操作(四)
- Python--struct模块