MySQL Forums
Forum List  »  Newbie

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
October 10, 2010 11:27PM
October 12, 2010 08:09AM
October 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.