快速业务通道

mysql 5安装遇到的问题

作者 佚名技术 来源 NET编程 浏览 发布时间 2012-03-18

1、[root@localhost bin]# ./MySQLd_safe –skip-grant-tables
出现以下信息:

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

解决办法:在/etc/my.conf中的mysqld这一节中加入:user=mysql

http://www.086php.com/index.php/rcd-2/566

凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务,公司网站:http://www.lingzhong.cn 为了给广大客户了解更多的技术信息,本技术文章收集来源于网络,凌众科技尊重文章作者的版权,如果有涉及你的版权有必要删除你的文章,请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息,谢谢!

分享到: 更多

Copyright ©1999-2011 厦门凌众科技有限公司 厦门优通互联科技开发有限公司 All rights reserved

地址(ADD):厦门软件园二期望海路63号701E(东南融通旁) 邮编(ZIP):361008

电话:0592-5908028 传真:0592-5908039 咨询信箱:web@lingzhong.cn 咨询OICQ:173723134

《中华人民共和国增值电信业务经营许可证》闽B2-20100024  ICP备案:闽ICP备05037997号