Another MySQL daemon already running with the same unix socket

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