MySQL manager or server PID file could not be found!



[root@centos var]# service mysqld stop

MySQL manager or server PID file could not be found![FAILED]

解决办法:

首先查看一下进程

[root@centos mysql]# ps aux |grep mysq*

root26430.00.245361224 ?S01:090:00 /bin/sh /usr/local/mysql/bin/mysqld_safe –datadir=/usr/local/mysql/var –pid-file=/usr/local/mysql/var/centos.pid

mysql27570.01.2369766608 ?Sl01:090:00 /usr/local/mysql/libexec/mysqld –basedir=/usr/local/mysql –datadir=/usr/local/mysql/var –user=mysql –log-error=/usr/local/mysql/var/centos.err –pid-file=/usr/local/mysql/var/centos.pid –socket=/tmp/mysql.sock –port=3306

root47880.00.13920684 pts/2R+11:110:00 grep mysq*

如果看到上面的内容,那说明,Mysql 的进程卡死了,这时用就要把这些卡死的进程都关闭

[root@centos mysql]# kill 2643

[root@centos mysql]# kill 2757

启动Mysql 就ok 了

[root@centos mysql]# service mysqld start

Starting MySQL.

偶的报错

MySQL manager or server PID file could not be found!

MySQL manager or server PID file could not be found!

MySQL manager or server PID file could not be found!

来自转载http://hi.baidu.com/xiaoyan_it/item/02298d5f3b98008c8d12ed67

Original: https://www.cnblogs.com/hshanghai/p/3625793.html
Author: 失忆王子
Title: MySQL manager or server PID file could not be found!

原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/606860/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

亲爱的 Coder【最近整理,可免费获取】👉 最新必读书单  | 👏 面试题下载  | 🌎 免费的AI知识星球