ian, [EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock [EMAIL PROTECTED] root]#
this my script of my.cnf [client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16K max_allowed_packet = 1M table_cache = 4 sort_buffer_size = 64K net_buffer_length = 2K thread_stack = 64K server-id = 1 ----- Original Message ----- From: ian douglas <[EMAIL PROTECTED]> To: Cecep Rosuludin <[EMAIL PROTECTED]> Subject: Re: Can't connect to local MySQL server through socket'/var/lib/mysql/mysql.sock' Date: Mon, 01 Nov 2004 17:48:27 -0800 > > > [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 > > -- _______________________________________________ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]