MySQL configuration issue Error ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/thesql/thesql.sock’ (2)

MySQLopensuse

I recently installed OpenSuse11.1 and tried configuring mysql with it however after installation I was not even able to start it off

I got the following error

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

As suggested in one of the forums I enabled the skip-networking option in /etc/my.cnf which did not help

I also tried binding it to the address using bind-address = 127.0.0.1 in the same /etc/my.cnf

Best Answer

I solved the problem. A after following the above steps I need to run rcmysql wwhich would configure it automatically.