Mysql problem

faris10 · 12-15-2005, 08:41 PM

I have installed suse, once I turn mysql I gives the next problem
Can't connect to local mysql throught socket '/var/lib/mysql/mysql.sock'(2)
any idea why ?

Matir · 12-15-2005, 10:15 PM

Is mysqld running? You can check with 'ps'. If so, does the file /var/lib/mysql/mysql.sock exist (and is a socket)? If it's not running, most distributions can start it with something like '/etc/init.d/mysql start' or something similar. Sorry, I'm not familiar enough with SuSE to give you a specific answer on starting mysqld.

onjoo · 12-16-2005, 07:58 AM

I had the same problem.
Shutting down and starting Mysql again didn't work.
I had to stop the service and delete mysql.sock (renamed to old.mysql.sock)

Suse does this behaviour sometimes after boot, its well know "feature".
It has something to do with the shutdown procedure, suse cannot stop the service on shutdown and the mysql.sock locks itself in some way.