If it truly ran fine for a few days and then you couldn't run the client, you may have another problem.
If you rebooted the box, mysqld may not have automatically started. So, all of the sudden, the client can't connect to the socket since it is not there as the server is not running. You can check the my.cnf file until your are blue in the face, but, if the server isn't running, then the socket file isn't anywhere to be found, no matter what is in my.cnf. By the way, I did this one to myself too! Ken Hylton -----Original Message----- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 3:45 PM To: 'azamka'; [EMAIL PROTECTED] Subject: RE: linux and mysql socket Your client is configured to connect via UNIX sock on localhost. It thinks the sock is on /tmp when it's probably /var/lib/mysql Take a look at /etc/my.cnf and make the change there or at the command line. -->-----Original Message----- -->From: azamka [mailto:[EMAIL PROTECTED] -->Sent: Thursday, June 19, 2003 1:07 PM -->To: [EMAIL PROTECTED] -->Subject: linux and mysql socket --> -->I installed mysql manually on red hat 9. It worked fine couple days but -->from -->yesterday i am getting a weird error when i tried to run the mysql. the -->error -->statement is " Error 2002: Can't connect to local MySql server through -->socket -->'/tmp/mysql.sock'(2). --> -->I am new user of Linux and I am unable to figure out why is this -->happening. -->Please help me. --> -->thanks in advance. -->Kamran --> --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]