解决MySQL is running but PID file
2020-02-18 本文已影响0人
周_0717
执行:sudo mysql.server status
报错:ERROR! MySQL is running but PID file could not be found
原因:mysql进程异常
解决办法:找到并kill掉所有关于mysql的进程
执行==》ps -ef | grep mysql 查看相关进程
执行==》kill 进程号
启动MySQL服务
sudo /usr/local/mysql/support-files/mysql.server start
停止MySQL服务
sudo /usr/local/mysql/support-files/mysql.server stop
重启MySQL服务
sudo /usr/local/mysql/support-files/mysql.server restart