ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.
I am having problem in connecting mysql database :
When I typed mysql -u root at shell prompt: I got the error..
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I ahve checked for file mysql.sock in mysql directory ..it isn't there..
I have changed permissions of folder mysql to 777..
changed owner and grp of all files under mysql folder to mysql...
I even tried mysqld_safe but didn't work at all...
Below I am pasting my /etc/my.cnf file for checking...
i tried it.
Strange thing is that there is no restart in /etc/init.d/mysql .
Ok there is something I didn't tell you about..
yesterday only I uograded cpanel with /scripts/upcp ..
and I think since then I got this error..I am very sure but I think it could be because of that or else ?
when I typed /etc/init.d/mysql stop i got this on my screen..
safe_mysqld mysqld mysqld_safe mysql
And then i typed /etc/init.d/mysql start
nothing happened at all..
I know musqld isn't running..
But I am able to trace error..
Please help dynamicnet
Should I restart server now because now eximstats also failed..
exim eximCould not create INET socket: Address already in use IO:ocket::INET: Address already in use