Another MySQL daemon already running with the same unix socket
Description:
When i try to restart mysql it is not starting.Able to stop the services but mysql is not starting.Here is the error,
Another MySQL daemon already running with the same unix socket
Root Cause:
– There is several possibilities to cause this error.If server was shoutdown graceful all services will stop intermediately.Later it will not start normally.
– Some cases if /tmp directory permission was gone it will stop the services.
– If you are unable to traceout the issue with the above two conditions check the log file located /var/log/mysqld.log
Solution:
– if the /tmp directory issue follow the below steps to reset back normal,
$ ls -ld /tmp
$ drwxrwxrwt 3 root root 16384 Dec 23 17:32 /tmp
– Issue with the socket need to remove the sock first,
$mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak
(or)
$rm -rf /var/lib/mysql/mysql.sock
– Now restart mysql services using the below command,
$service mysqld restart
Tags:mysql,soc error,mysql error,centos,centos server,Linux BSD,Hosting article,Tech News
Add Comment