MySql problem ( Urgent Help)

[shann]

Hi,

Suddenly mysql start to give some problem on the server and all the site giving this error mesage.

mySQL error: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)
mySQL error code: 2002
Date: Friday 25th of July 2003 10:08:42 AM

Any help woudl be appreciate.

When we look at /var/tmp/ there is no mysql.sock file. Any help woudl be appreciate.

Thanks
MIke

cPanel.net Support Ticket Number:

 

[casey]

You should have a symlink to it from /var/lib/mysql/mysql.sock

cPanel.net Support Ticket Number:

 

[shann]

Thanks guys it is fixed.

cPanel.net Support Ticket Number:

 

[moogle]

What's the command to create the symlink?

cPanel.net Support Ticket Number:

 

[euselect]

the command is ln ( man ln )

example :

ln -s real_file new_sym_link

HTH

Neil

cPanel.net Support Ticket Number:

 

[gundamz]

Originally posted by casey
You should have a symlink to it from /var/lib/mysql/mysql.sock

cPanel.net Support Ticket Number:

why should yuo create a symlink to fix this problem?

cPanel.net Support Ticket Number:

 

[ciphervendor]

Originally posted by gundamz
why should yuo create a symlink to fix this problem?

cPanel.net Support Ticket Number:

Different applications look for the mysql.sock file in different locations.

cPanel.net Support Ticket Number:

 

[Munch]

I didnt work for me...Help!!!

I created the sym link in /var/lib/mysql/ to /var/tmp/mysql.sock and still recieved the same error.

Is t suppose to be the other way around? The /var/tmp/mysql.sock is a link. Is that linking to the /var/lib/mysql/mysql.sock and the mysql.sock just doesnt exist?

Please Help!!!

cPanel.net Support Ticket Number:

 

[NNNils]

search google for "mysql error code: 2002"

cPanel.net Support Ticket Number:

 

[ciphervendor]

Execute:

slocate mysql.sock

then reply back with the output.

cPanel.net Support Ticket Number:

 

[Blackthorne]

I had the same problem with /var/lib/mysql.sock, the soft link didn't fix it.

I updated the permissions on /var/lib/mysql to 755 and mysql works now. :D

cPanel.net Support Ticket Number: