重新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. [确定]