分类: Mysql/postgreSQL
2009-11-06 10:50:06
今天在centos5.2下安装mysql 5.1.30的时候出现 mysql错误
MySQL manager or server PID file could not be found![FAILED]
Starting MySQL.Manager of pid-file quit without updating file.[FAILED]
出现这种情况的原因好多,赶紧找出错误日志查看什么原因出错
默认的mysql错误日志是在/usr/local/mysql/data 下面 以hostname.err的形式存在
我的是在/data/mysql/data下面
cat njcitweb.njcit.edu.cn.err
090105 20:47:28 mysqld_safe Starting mysqld daemon with databases from /data/mysql/data
090105 20:47:29 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-federated'
090105 20:47:29 [ERROR] Aborting
090105 20:47:29 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
090105 20:47:29 mysqld_safe mysqld from pid file /data/mysql/data/njcitweb.njcit.edu.cn.pid ended
090105 20:53:43 mysqld_safe Starting mysqld daemon with databases from /data/mysql/data
此时 知道错误原因了:
只要将/etc/my.cnf里面的 skip federated注释掉即可。