ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.

SpellChainz · 06-26-2007, 01:31 PM

Hi

I have installed centOS now and deleted red hat...i have installed all the package in mysql i have checked all th boxes while installing mysql,and i have confirmed it through add remove programs.....its all checked but when i try to connect MySql i get the following message...

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

i dont know wht to do ....
Can some one help me please....
i ll be very thankfulll....
thnxx.....

Wim Sturkenboom · 06-26-2007, 11:39 PM

Is the MySql server running? No longer familiar with RH and clones, so can't tell you how to start it.

SpellChainz · 06-28-2007, 10:42 AM

hi....
no my sql server is not running...and is not getting connected...
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
i get the above message while connecting....
plz do help me ...
thnxx

Wim Sturkenboom · 06-28-2007, 11:46 AM

If the server is not running, that is the obvious response that the client gives you (as it can't connect). So get your server running (as I said, I don't know how as I'm not familiar with your distro) and try again to connect.

Note:
There are two programs to mysql. mysqld is the actual server and needs to be started first; mysql is the 'standard' client that can be used to communicate with the server (once the server is running).