启动MySQL时出现错误提示:
Starting MySQL. ERROR! The server quit without updating PID file (/home/mysql/log/mysql.pid).
遇到问题,先想到看日志
# less /home/mysql/log/mysql13306_error.log
141205 15:11:51 mysqld_safe Starting mysqld daemon with databases from /home/mysql/data
/home/mysql/bin/mysqld: File '/home/mysql/log/binlog/binlog.index' not found (Errcode: 2)
141205 15:11:51 [ERROR] Aborting
141205 15:11:51 [Note] /home/mysql/bin/mysqld: Shutdown complete
141205 15:11:51 mysqld_safe mysqld from pid file /home/mysql/log/mysql13306.pid ended
141205 15:12:54 mysqld_safe Starting mysqld daemon with databases from /home/mysql/data
可以看到红色部分提示很明显。找不到/home/mysql/log/binlog/binlog.index文件
如果不看日志,只是根据启动时的错误提示,就会想我一样,拼命的研究pid文件,苦寻不得解