1 問題

[root@localhost mysql]# /etc/rc.d/init.d/mysql status

MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]

[root@localhost mysql]# /etc/rc.d/init.d/mysql start

Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).??????????????????????????????[FAILED]

2 原因

沒有初始化權限表

3 解決辦法

#cd /usr/local/mysql(進入mysql安裝目錄)

#chown -R mysql:mysql? .

$scripts/mysql_install_db

4 本人解決過程

[root@localhost ~]#cd /usr/local/mysql

[root@localhost mysql]#chown -R mysql.mysql?.

[mysql@localhost mysql]$scripts/mysql_install_db

[mysql@localhost mysql]$/usr/local/mysql/bin/mysqld_safe --user=mysql &

然后/tmp 目錄下就出來了mysql.sock文件，運行service mysqld start

mysql服務啟動成功。

借鑒文章：http://blog.csdn.net/caiyaodeng/article/details/45937183

這個問題也是困惱了我一個下午，終于通過這篇文章解決了，其中原理不是很懂，有什么不對的地方，請各位大佬指教。