Hello guys,
Today I faced new issue, when I was starting the mysqld service, it was throwing an error as below.
Quote#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.
Quote# mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.backup
# service mysqld start
Starting mysqld: [ OK ]