MySQL Forums :: Newbie :: MySQL Socket Error


Advanced Search

MySQL Socket Error
Posted by: DigiOz Multimedia ()
Date: October 10, 2010 11:27PM

Hello All,

I am new to this forum so please excuse me if I am posting this in the wrong forum.

We were getting the following error with our Database:

Error 1: Too Many Connections

I talked to our web host's live chat tech support and they told me two issues caused
this:

1. Disk Space was full 100% (which I fixed by removing backup file).
2. SELinux was interfering with MySQL start (which I fixed by disabling SELinux)

After I rebooted the server I started mysqld (command executed OK), but I
noticed the file "mysql.sock" was missing, which caused us to see the following
error:

Error 2: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) [2002]

I changed the socket setting in /etc/my.cnf to point to "/var/temp/mysql.sock"
and restarted mysql, which created a new mysql.sock in the new directory, but
the error still remains.

Does anyone have any other suggestions on how to fix this issue?

Thanks,
Pete

Options: ReplyQuote


Subject Written By Posted
MySQL Socket Error DigiOz Multimedia 10/10/2010 11:27PM
Re: MySQL Socket Error Rick James 10/12/2010 08:09AM
Re: MySQL Socket Error DigiOz Multimedia 10/12/2010 08:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.