Another MySQL daemon already running with the same unix socket.

1 문제상황

서버 과부하로 강제 재부팅 후 MySQL 시작이 안되는 현상

MySQL 서비스 시작시 오류

[root@zetawiki ~]# service mysqld start
Another MySQL daemon already running with the same unix socket.
Starting mysqld:                                           [FAILED]

phpMyAdmin 접속시 오류

phpMyAdmin - Error
#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
The server is not responding (or the local server's socket is not correctly configured).

2 조치

[root@zetawiki ~]# cat /etc/my.cnf | grep ^socket
socket=/var/lib/mysql/mysql.sock

[root@zetawiki ~]# rm -f /var/lib/mysql/mysql.sock
[root@zetawiki ~]# service mysqld start
Starting mysqld:                                           [  OK  ]

3 같이 보기

• Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'