重新linux后,mysql无法运行,提示以下错误

执行service mysql stop/start时:
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL......

解决方法:

解决办法

首先获取自己的主机名

#cat /etc/hosts

127.0.0.1               localhost localhost.localdomain localhost

进入数据库的VAR下

cd /usr/local/mysql/var

echo `ps aux | grep mysql | grep "user=mysql" | grep -v "grep" | awk '{print $2}'`>>localhost.localdomain.pid

[root@localhost var]# service mysql status
MySQL running (8421)                                       [确定]
[root@localhost var]# service mysql restart
Shutting down MySQL.                                       [确定]
Starting MySQL.                                                   [确定]

 

Last modification:July 14, 2020
如果觉得我的文章对你有用,请随意赞赏