[root@localhost ~]# /etc/init.d/mysql stop MySQL server PID file could not be found! [失败] [root@localhost ~]# ps aux | grep mysql root 2204 0.0 0.3 5732 952 ? S Jun15 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/localhost.localdomain.pid mysql 2456 0.0 2.5 331604 6556 ? Sl Jun15 0:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/localhost.localdomain.err --pid-file=/usr/local/mysql/data/localhost.localdomain.pid --socket=/tmp/mysql.sock --port=3306 root 18224 0.1 0.4 5684 1168 pts/3 S 02:07 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/localhost.pid mysql 18476 0.6 10.4 285288 26608 pts/3 Sl 02:07 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/localhost.err --pid-file=/usr/local/mysql/data/localhost.pid --socket=/tmp/mysql.sock --port=3306 root 18593 0.0 0.2 5108 672 pts/3 R+ 02:08 0:00 grep mysql
解决办法:
将所有mysql的进程kill掉,重新启动
[root@localhost ~]# /etc/init.d/mysql start Starting MySQL... [确定] [root@localhost ~]# ps aux | grep mysql root 18618 1.1 0.4 5684 1168 pts/3 S 02:08 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/localhost.pid mysql 18870 4.5 12.8 329692 32796 pts/3 Sl 02:08 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/localhost.err --pid-file=/usr/local/mysql/data/localhost.pid --socket=/tmp/mysql.sock --port=3306 root 18919 0.0 0.2 5108 672 pts/3 R+ 02:09 0:00 grep mysql [root@localhost ~]# /etc/init.d/mysql stop Shutting down MySQL. [确定]