mysql failed: dbi error

chadi · 10-30-2004, 10:39 PM

DBI connect('mysql:localhost','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /scripts/restartsrv_mysql line 56 mysql has failed, please contact the sysadmin (result was "mysql has failed").

I tried restarting MySQl and got that error above.

updated apached as well, still the same.

How to fix this?

Thanks in advance.

crabboy · 10-30-2004, 10:57 PM

Sounds like your trying to start a msyql client session and not the server. Is the server running? ps -ef | grep mysqld

Try running safe_mysqld to start the server and see if the socket file under /var/lib/mysql gets created. The error returned (2) indicates that the file does not exist, likely cause the server is not running.