mysql socket problem

phpprog

We are using virtual hosting for the websites.
Today suddenly all our websites broke

The error was

Warning:MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Warning: MySQL: A link to the server could not be established
can anybody help

theeper

I had a similar problem once and it turned out to be a DNS issue. My DB server couldn't properly reverse map the name of the server with the websites on it and therefore it broke. The easy solution was to have MySQL not do the lookup on the website box.

I added a line in the my.cnf file that looks something like this...

skip-name-resolve

and it works ok now. I am not sure what the real answer is here, if anyone knows please let me know as the manual seems to lack info on how MySQL handles this.

Make sure the socket file exists though, could be simple as that.

lostcarpark

I had the same thing once, and it turned out my ISP had taken MySQL off localhost and put it on its own server. It would have been a good idea if they'd thought to tell their clients!

Needless to say I'm no longer with that ISP...

James