# service mysqld stop
如无法暂停,就把整个LNMP暂停了
#./lnmp stop
MySQL manager or server PID file could not be found! [FAILED]
解决办法:
首先查看一下进程
# ps aux |grep mysq*
root 9677 0.0 0.1 63804 1328 pts/1 S Apr12 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe –datadir=/usr/local/mysql/var –pid-file=/usr/local/mysql/var/AY***.pid
root 9738 0.0 0.0 61148 760 pts/0 R+ 08:41 0:00 grep mysq*
mysql 9780 0.0 0.8 45300 8312 pts/1 Sl Apr12 0:00 /usr/local/mysql/libexec/mysqld –basedir=/usr/local/mysql –datadir=/usr/local/mysql/var –user=mysql –log-error=/usr/local/mysql/var/AY**.err –pid-file=/usr/local/mysql/var/AY**.pid –socket=/tmp/mysql.sock –port=3306grep mysq*
root 9738 0.0 0.0 61148 760 pts/0 R+ 08:41 0:00 grep mysq*
mysql 9780 0.0 0.8 45300 8312 pts/1 Sl Apr12 0:00 /usr/local/mysql/libexec/mysqld –basedir=/usr/local/mysql –datadir=/usr/local/mysql/var –user=mysql –log-error=/usr/local/mysql/var/AY**.err –pid-file=/usr/local/mysql/var/AY**.pid –socket=/tmp/mysql.sock –port=3306grep mysq*
如果看到上面红色字体的内容,那说明,Mysql的进程卡死了,这时用就要把这些卡死的进程都关闭
# kill 9677
# kill9780
启动Mysql就ok了
# service mysql start
Starting MySQL.
如果杀掉进程之后还是不行。
具体要看报错信息 如果没有指定日志路径 一般在是 /data/mysql 中的localhost.err文件中可以看到信息。
如果线程中无死进程 可以先看 service mysql status 看下状态 根据提示删掉多余的东西
进入/data/mysql 也就是你的数据库目录 把多余的删除,包括localhost.err 和其他 index等东西
如果 多重启几次 一直执行 service mysql start 就可以重启成功了