mysql启动时报错--ERROR! MySQL server PID file could not be found!
2012-12-12 13:41:10
MySQL
[root@localhost mysql]#service mysql restart 启动时出现如下错误。
ERROR! MySQL server PID file could not be found!
解决办法:
1.查看mysql进程是否存在。
root@localhost mysql]# ps aux | grep mysql 如果出现如下信息,说明mysql进程卡死了。
root 1215 0.0 0.0 108164 1620 ? S Dec11 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/localhost.localdomain.pid
mysql 1527 0.0 1.4 1026644 110480 ? Sl Dec11 0:09 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/localhost.localdomain.err --pid-file=/data/mysql/localhost.localdomain.pid --socket=/data/mysql/mysql.sock --port=4425
root 4569 0.0 0.0 103240 868 pts/0 S+ 13:22 0:00 grep mysql
2.结束卡死的mysql进程即可!!!
[root@localhost mysql]# kill 1215
[root@localhost mysql]# kill 1527
3.重启ok.
[root@localhost mysql]# service mysql start
Starting MySQL... SUCCESS!
本文出自 “贵在坚持” 博客,请务必保留此出处http://whlai51.blog.51cto.com/2164371/1086614
--转自