Can't connect to local MySQL server through socket '/tmp/mysql.sock'

[gopederick]

Hello, my mysql suddonly stopped working. It was compltely random.

mySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
mySQL error code:

I get that error.

I tried to copy it into tmp folder from /var/db/mysql/ but it says it exists... but it does not.

cp1# cp -rf /var/db/mysql/mysql.sock ../../tmp/
cp: symlink: /tmp/mysql.sock: File exists

Please help.

thx.

If all else fail what would be the best way to copy the databases reinstall mysql and put the databases back?

[linux-image]

cd /tmp

rm -rf mysql.sock

ln -s /var/lib/mysql/mysql.sock mysql.sock

that will do.

[gopederick]

That doesn't work :\

cp1# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (62)

Btw I am on freebsd 4.8 with mysql (4.0.10-gamma)

Maybe I can just uninstall mysql and make cpanel reinstall it with a cpanel update? How would i uninstall cpanel without deleting/remove the current databases.

thx.

[linux-image]

freebsd am not sure the..

also you can try a restart for the mysql that will create the socket the natural way.

[eger]

i am having this problem also on my freebsd 4.10 box. was there ever a solution for this?

[AlexF]

Try this:

/usr/local/bin/mysqld &