[EMAIL PROTECTED] root]# ls -l /var/lib/mysql
total 20564
-rw-rw----  1 mysql mysql    25088 Nov  1 14:10 ib_arch_log_0000000000
-rw-rw----  1 mysql mysql 10485760 Nov  2 07:39 ibdata1
-rw-rw----  1 mysql mysql  5242880 Nov  2 07:39 ib_logfile0
-rw-rw----  1 mysql mysql  5242880 Nov  1 14:10 ib_logfile1
drwx--x--x  2 mysql mysql     4096 Feb 23  2004 mysql/
-rw-rw----  1 mysql root      7509 Nov  2 07:39 server6.cma-cgm.com.err
drwxr-xr-x  2 mysql mysql     4096 Feb 23  2004 test/

Therein lies your problem: you can't connect to /var/lib/mysql/mysql.sock if it doesn't exist :o)


RedHat was notorious for putting mysql.sock in /tmp/ ... perhaps check that path to see if the socket file exists there, and do one of the following:

(a) symlink it to /var/lib/mysql:

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

-OR-

(b) modify your MySQL configuration (check for /etc/my.cnf):

        under the "[mysqld]" heading:

        socket=/var/lib/mysql/mysql.sock

... set that path and filename to wherever your mysql.sock file lives.

You could try using:

        locate mysql.sock

... to find the file for you as well.

-id


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to