mysql问题不断

2012-5-23 17:18 668 0

摘要: 今天在安装mysql的时候，编译与安装过程顺利！但在启动老失败,查看错误日志显示：mysqld_safe Starting mysqld daemon with databases from /usr...

关键词： mysql mysqld local 091120 usr webserver nbsp shutdown Starting 10

今天在安装mysql的时候，编译与安装过程顺利！但在启动老失败,查看错误日志显示：mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't existCan't open the mysql.plugin table. Please run mysql_upgrade to create it. 查是执行scripts/mysql_install_db --user=mysql没有成功的原因，没有一个初始化数据库，不能启动mysql守护进程，重新执行:/usr/src/mysqlXXX/scripts/mysql_install_db --datadir=/usr/local/mysql/date --user=mysql 解决。然而恶梦还没结束，再次启动mysql服务时又报错.查看错误日志如下:091120 10:54:14 mysqld_safe mysqld from pid file /usr/local/webserver/mysql/data/localhost.pid ended091120 10:57:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/webserver/mysql/data091120 10:57:25 InnoDB: Started; log sequence number 0 46409091120 10:57:25 [ERROR] /usr/local/webserver/mysql/libexec/mysqld: unknown option '--skip-federated'091120 10:57:25 [ERROR] Aborting 091120 10:57:25 InnoDB: Starting shutdown...091120 10:57:26 InnoDB: Shutdown completed; log sequence number 0 46409091120 10:57:26 [Note] /usr/local/webserver/mysql/libexec/mysqld: Shutdown complete 解决办法:打开my.cnf文件找到 skip-federated 注释掉就可以了. 本文出自 “林中路” 博客，请务必保留此出处http://juven.blog.51cto.com/749867/231015

声明：文章版权归原作者所有部分文章转自互联网如有侵权请联系 [邮箱地址] 删除