解决MySQL is running but PID file could not be found

执行: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        
posted @ 2020-10-09 16:46  FirstLetterZ  阅读(1954)  评论(0)    收藏  举报