Mysql- "Another MySQL daemon already running with the same unix socket."

[Dipak Bhoi]

Hello guys,

Today I faced new issue, when I was starting the mysqld service, it was throwing an error as below.

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

I tried all possible ways to kill the process of mysqld, rebooted my VPS, but it was of no help.

Further investigating, I found that the file /var/lib/mysql/mysql.sock. I have just moved this file as /var/lib/mysql/mysql.sock.backup and had tried to start the service, WOW! problem was solved.

# mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.backup

# service mysqld start
Starting mysqld:                                           [  OK  ]