[CentOS] MySQL stale socket

[Jake Shipton]

On Mon, 16 Dec 2013 10:51:54 +0100
Luigi Rosa <lists at luigirosa.com> wrote:

> 
> I have a server with a faulty power supply that resets the server
> every 4/5 hours.
> 
> While I wait for the supplier to change the PS, I am facing an issue
> with MySQL.
> 
> When the system comes back on, mysqld script starts the daemon, but
> the connections via /var/lib/mysql/mysql.sock don't work because
> MySQL doesn't delete and recreate the stale socket.
> 
> Apart from editing /etc/init.d/mysqld to force the deletion of a
> stale socket are there any other way to solve this issue?
> 
> 
> Thank you un advance.
> 
> 
> Ciao,
> luigi
> 
> 
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos

Hi, 

As a *temporary* solution you could do the following:

# chkconfig mysqld off
# nano /etc/rc.local
 Add at bottom: 
  rm /var/lib/mysql/mysql.sock
  service mysqld start
 Now Save.

Next time the machine boots it should remove the sock file, and then
start mysqld.

Once your PSU is fixed, remove those lines and run:

# chkconfig mysqld on

Job done! :-D

Hope this helps.

Kind Regards, 
Jake Shipton (JakeMS)
GPG Key: 0xE3C31D8F
GPG Fingerprint: 7515 CC63 19BD 06F9 400A DE8A 1D0B A5CF E3C3 1D8F