您的位置:首页技术文章

mysql 5安装遇到的问题

浏览:80日期:2023-08-08 11:28:42

、[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 4294967295090724 12:05:13 [Warning] option ‘max_join_size’: unsigned value 18446744073709551615 adjusted to 4294967295ERROR: 1062; Duplicate entry ‘localhost-’ for key 1090724 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 mysqldatabase and look at the grant tables:http://www.knowsky.com/shell> /usr/local/mysql5/bin/mysql -u root mysqlmysql> show tables

Try ‘mysqld –help’ if you have problems with paths. Using –loggives you a log in /var/lib/mysql5 that may be helpful.

The latest information about MySQL is available on the web athttp://www.mysql.comPlease 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 4294967295090724 12:05:34 [Warning] option ‘max_join_size’: unsigned value 18446744073709551615 adjusted to 4294967295090724 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

标签: MySQL 数据库
相关文章: