I had this same error message yesterday when I first set up MySQL. Two possible reasons:
1) Is mysqld running? I used bash2.05$ ps aux | grep mysqld to see if there is a process called "mysqld". 2) In my installation (which I compiled from source, with the Unix socket path option in configure) bash2.05$ pwd /usr/home/eprice/build-mysql-3.23.44/ bash2.05$ ./configure --with-unix-socket-path=/usr/local/mysql/run/mysql-socket This sets the location of the Unix socket to /usr/local/mysql/run/mysql-socket . So when you start MySQL daemon, you must specify the socket path: /usr/local/mysql/bin/safe_mysqld --socket=/usr/local/mysql/run/mysql-socket & If you installed MySQL from a binary package/RPM, I am not sure where the socket is located by default. Check the package documentation. The MySQL documentation (www.mysql.com) suggests that you may have "cron" set to clean up files in /tmp . If this is true, then "cron" may have removed your Unix socket file. You must restart the MySQL daemon and change cron (or change the socket location). I am very new to MySQL but I have had this same experience so I thought I would share my own discovery. check this page: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Erik --- "R.Neubert" <[EMAIL PROTECTED]> wrote: > and this is wrong: > > [root@linux mysql]# mysqladmin reload > mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2)' > Check that mysqld is running and that the socket: > '/var/lib/mysql/mysql.sock' exists! ===== Microsoft e[X]tra [P]roprietary -- Is this where you really wanted to go today ? -- http://www.redhat.com/about/opinions/xp.html __________________________________________________ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
