安裝完mysql后，啟動MYSQL時發現報錯，提示如下：[root@web-server log]# /etc/rc.d/init.d/mysqld startStarting MySQL. ERROR! Manager of pid-file quit without updating file.

看下日志：[root@web-server log]# cat alert.log100811 10:22:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data100811 10:22:57 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead./usr/local/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)100811 10:22:57 [ERROR] Aborting

100811 10:22:57 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

100811 10:22:57 mysqld_safe mysqld from pid file /usr/local/mysql/data/web-server.pid ended100811 10:26:38 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data100811 10:26:38 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead./usr/local/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)100811 10:26:38 [ERROR] Aborting

100811 10:26:38 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

100811 10:26:38 mysqld_safe mysqld from pid file /usr/local/mysql/data/web-server.pid ended;

在網上找了如下方法，但依舊無法解決：

有人說將/etc/my.cnf里面的 skip federated注釋掉即可，但我的my.cnf里壓根就沒有這一項，還有人說/etc/my.cnf中沒有設置datadir=/data/mysql，但我看了這一項已經有了。還有說data/mysql-bin.index沒有刪除，data/mysql-bin.index是存放日志文件索引的文件，只刪除了日志文件而沒有對日志的索引文件做處理顯然是不行的。但刪除data/mysql-bin.index文件，再service mysqld start還是不行。

應該如何解決呢？

今天終于搞定了

mysql編譯如下：

CHOST="x86_64-pc-linux-gnu"CFLAGS="-march=nocona -O3 -pipe"CXXFLAGS="${CFLAGS}"./configure "--prefix=/usr/local/mysql" "--localstatedir=/data/mysql/data" "--with-comment=Source" "--with-mysqld-user=mysql" "--without-debug" "--with-big-tables" "--with-charset=gbk" "--with-collation=gbk_chinese_ci" "--with-extra-charsets=all" "--with-pthread" "--enable-static" "--enable-thread-safe-client" "--with-client-ldflags=-all-static" "--with-mysqld-ldflags=-all-static" "--enable-assembler" "--with-plugins=all" "--without-ndb-debug

makemake installuseradd mysql -d /data/mysql -s/sbin/nologin/usr/local/mysql/bin/mysql_install_db--user=mysqlcd /usr/local/mysqlchown -R mysql:mysql . 這一步一定要搞清楚，不要照網上的亂抄，到時候啟動mysql時會因為目錄權限問題而導致出錯！謹記。mkdir -p /data/mysql/datachown -R mysql /data/mysql/datacp share/mysql/my-huge.cnf /etc/my.cnfcp share/mysql/mysql.server/etc/rc.d/init.d/mysqldchmod 755 /etc/rc.d/init.d/mysqldchkconfig --add mysqld/etc/rc.d/init.d/mysqld start;;cd /usr/local/mysql/binfor i in *; do ln -s /usr/local/mysql/bin/$i/usr/bin/$i; done

這樣，問題就解決了[root@web-server local]# service mysqld startStarting MySQL.