MySQL 5安装过程中遇到的问题的解决

php中文网

发布时间：2016-06-07 16:09:38

1281人浏览过

来源于php中文网

原创

以下的文章主要是对MySQL 5安装的过程中遇到的相关问题的解决，本文主要是以代码的方式来对MySQL 5安装的相关问题的详细解析，如果你对其实际的操作有兴趣的话，你就可以浏览以下的文章了。 1、[root@localhost bin]# ./MySQLd_safe skip-grant-tables 出现

以下的文章主要是对mysql 5安装的过程中遇到的相关问题的解决，本文主要是以代码的方式来对mysql 5安装的相关问题的详细解析，如果你对其实际的操作有兴趣的话，你就可以浏览以下的文章了。

1、[root@localhost bin]# ./MySQLd_safe –skip-grant-tables

出现以下信息：

行业贸易网站管理系统 2007 Beta 1

1.修正BUG站用资源问题,优化程序2.增加关键词搜索3.修改报价4.修正BUG 水印问题5.修改上传方式6.彻底整合论坛,实现一站通7.彻底解决群发垃圾信息问题。注册会员等发垃圾邮件7.彻底解决数据库安全9.修改交易方式.增加网站担保,和直接交易两中10.全站可选生成html.和单独新闻生成html(需要装组建)11. 网站有10中颜色选择适合不同的行业不同的颜色12.修改竞价格排名方式13.修

下载

Installing MySQL system tables…  
090724 12:05:13 [Warning] option ‘max_join_size’: 
unsigned value 18446744073709551615 adjusted to 4294967295  
090724 12:05:13 [Warning] option ‘max_join_size’: 
unsigned value 18446744073709551615 adjusted to 4294967295  
ERROR: 1062 Duplicate entry ‘localhost-’ for key 1  
090724 12:05:13 [ERROR] Aborting  
090724 12:05:13 [Note] /usr/local/MySQL5/libexec/MySQLd: Shutdown complete  
Installation of system tables failed!  
Examine the logs in /var/lib/MySQL5 for more information.  
You can try to start the MySQLd daemon with:  
/usr/local/MySQL5/libexec/MySQLd –skip-grant &  
and use the command line tool  
/usr/local/MySQL5/bin/MySQL to connect to the MySQL  
database and look at the grant tables:  
http://www.knowsky.com/  
shell> /usr/local/MySQL5/bin/MySQL -u root MySQL  
MySQL> show tables  
Try ‘MySQLd –help’ if you have problems with paths. Using –log  
gives you a log in /var/lib/MySQL5 that may be helpful.  
The latest information about MySQL is available on the web at  
http://www.MySQL.com  
Please consult the MySQL manual section: ‘Problems running MySQL_install_db’,  
and the manual section that describes problems on your OS.  
Another information source is the MySQL email archive.  
Please check all of the above before mailing us!  
And if you do mail us, you MUST use the /usr/local/MySQL5/bin/MySQLbug script!

2、[root@localhost bin]# /usr/local/MySQL5/libexec/MySQLd –skip-grant &

出现以下信息：

[1] 6633  
[root@localhost bin]# 090724 12:05:34 [Warning] option ‘max_join_size’: 
unsigned value 18446744073709551615 adjusted to 4294967295  
090724 12:05:34 [Warning] option ‘max_join_size’: 
unsigned value 18446744073709551615 adjusted to 4294967295  
090724 12:05:34 [ERROR] Fatal error: Please read “Security” 
section of the manual to find out how to run MySQLd as root!  
090724 12:05:34 [ERROR] Aborting  
090724 12:05:34 [Note] /usr/local/MySQL5/libexec/MySQLd: Shutdown complete  
[1]+ Exit 1 /usr/local/MySQL5/libexec/MySQLd –skip-grant