mysql啟動報錯-server PID file could not be found解決
[root@yunhe ~]# service mysql stop
MySQL server PID file could not be found! [失敗]
www.2cto.com
解決方案如下:
首先查看下與mysql有關的進程
[root@yunhe ~]# ps aux |grep mysq*
root 2019 0.0 0.1 6228 1392 ? S 09:22 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/yunhe.pid
mysql 2115 0.0 2.9 353596 30808 ? Sl 09:22 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/yunhe.err --pid-file=/var/lib/mysql/yunhe.pid
500 4258 0.0 1.6 83432 17484 ? S 09:35 0:01 gedit /usr/share/mysql/my-medium.cnf
root 5555 0.0 0.0 5936 768 pts/0 S+ 10:04 0:00 grep mysq*
如果看到上面的內容,那說明mysql相關的進程存在,不過資源調度出現了問題(好像卡死),這時用就要把這些卡死的進程都關閉。
[root@yunhe ~]# kill 2019
[root@yunhe ~]# kill 20115
-bash: kill: (20115) - 沒有那個進程
[root@yunhe ~]# kill 2115
www.2cto.com
然後重新啟動mysql
[root@yunhe ~]# service mysql start
Starting MySQL... [確定]
[root@yunhe ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.4-m7 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>