MySql cannot start:Another MySQL daemon already running with the same unix socket
Sometimes you may got a mysql can not start issue, shows error "Another MySQL daemon already running with the same unix socket"
[www.comfortvps.com]# service mysqld restart
Stopping mysqld: [ OK ]
Another MySQL daemon already running with the same unix socket.
Starting mysqld: [FAILED]
[www.comfortvps.com]# ps -ef | grep mysql
root 4825 4774 0 01:11 pts/0 00:00:00 grep mysql
this means mysql.sock exists
How to fix it?
Based on Centos, an additional method for getting it back up again when you run into this problem is to move mysql.sock:
[www.comfortvps.com]# mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak
[www.comfortvps.com]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]