NEED HELP Can't connect to local MySQL server error message

francright · 01-25-2009, 03:34 PM

I am getting this error message
What can I do to recorrect this message

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /homepages/38/d273307294/htdocs/pets_osc/pets_osc/010/includes/functions/database.php on line 18
Unable to connect to database server!
What can I do to fix this

irishbitte · 01-25-2009, 05:00 PM

Well, first question, is your mysql server running?

This command:

Code:

ps ax | grep mysql

returns something like:

Code:

 5492 ?        S      0:00 /bin/sh /usr/bin/mysqld_safe
 5534 ?        Sl     0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
 5535 ?        S      0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
 9562 pts/0    S+     0:00 grep mysql

for me. If it's not similar for you, the server daemons have stopped running for some reason. If you find the file(s) named mysql.log and take a look through them, you should get some info to help you.

This will help you find them:

Code:

locate mysql.log*

robertjinx · 01-26-2009, 01:53 AM

Try to restart mysql server, try to login to mysql server thru command line: mysql -u user -p, see if it works and also see if you have mysql.sock.