Today I had a little drama. I noticed that one of my servers was not working at all since the MySQL server was down. Initially I thought that maybe it was a problem of lack of free space in the hard drive. But it wasn’t. I am running CentOS in a 1and1 virtualserver.
This is the problem:
$ service mysqld restart
Stopping mysqld: [ OK ]
Another MySQL daemon already running with the same unix socket.
Starting mysqld: [FAILED]
So I started searching and found the solution:
$ mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak
$ service mysqld start
Starting mysqld: [OK]
This sorted it out nicely 🙂
Thanks to GeckoSEO for his solution in StackOverflow http://stackoverflow.com/questions/20407292/centos-another-mysql-daemon-already-running-with-the-same-unix-socket