ERROR! MySQL is running but PID file could not be found
centos中启动、重启,或者查看mysql状态时报错
ERROR! MySQL is running but PID file could not be found
解决
第一步:找到 mysql 目录下的 mysql-bin.index 文件,然后删除
find / -name mysql-bin.index
/usr/local/mysql/var/mysql-bin.index
rm -rf /usr/local/mysql/var/mysql-bin.index
第二步:找到 并 kill 所有关于 mysql 或者 mysqld 的进程
ps -aux | grep mysql
kill XXXX