mysql重置密码后遇到的问题
解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误这个问题其实是 没有杀死 mysqld_safe 进程导致的
然后我执行service mysqld stop
# service mysqld stop
MySQL manager or server PID file could not be found!
解决办法：
首先查看一下进程
# ps aux |grep mysq*
root 26430.00.2 45361224 ? S 01:09 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/centos.pid
mysql 27570.01.2369766608 ? Sl 01:09 0: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
root 47880.00.1 3920 684 pts/2 R+ 11:11 0:00 grep mysq*
如果看到上面的内容，那说明，Mysql的进程卡死了，这时用就要把这些卡死的进程都关闭
# kill 2643
# kill 2757
启动Mysql 就ok了
# service mysqld start
Starting MySQL.
页:
[1]