Entry

Cannot connect through socket '/tmp/mysql.sock'

Redhat Linux 7.2 error "can't connect to local mysql server through socket '/var/lib/mysql/mysql.soc

Feb 22nd, 2008 20:24
dman, akt akt, Terry Ashely, Barry Munro, Rick G, chiu wing hing raymond, http://sturly.com

Don’t forget to type in /etc/rc.d/ mysql start in your command line if 
your on Linux. Please note that you will have to set up a username and 
password at a later time.

there are many other ways to do it as often many people get this error 
with diferent reasons:
1) try this out: (only if the errror no. is error2002 or mysql.sock 
(2)))
try killing the mysql process (which are still running in some cases 
and are hidden somewhere even when mysql has died!!)
#killall mysql 
or try mysqld
(if it kills the process then try doing this untill You get a message 
like:
mysql:no more process to kill....
then try to restart the mysql service....
2) if this do not work try:
log in  into shell and find the file .my.cnf (normally located in /root)
(root@root)#cat .my.cnf
take the password and loginto WHM or any other wehosting management 
tool and find "mysql" category in that find "change mysql localhost 
password"
option click on it and set the password and click change password...
do not worry the password is the same already, its just that this trick 
causes the mysql to restart totally with the new password:
this should fix ur problem.....

(in case the above 2 methods do not work cantact me at 
pals_oo7@indiatimes.com so that i can help You out much better: