[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]