AHH! Cannot connect through socket error.

[Guest_imported]

I am using Red Hat 7.1, and am installing MySQL from the RPM package, and whenever I try to connect to mysql, via browser, via shell, I get the following error:

Error

MySQL said:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I am boggled. What's going on?

 

[rninja]

Where is the mysql.sock located?
Try using the command "locate mysql.sock" or "whereis mysql.sock" to find out. I am betting it's in /tmp/mysql.sock. If that is the case, you will have to recompile the mysql source rpm or tar.gz file with an option to change the location of mysql.sock to /var/lib/mysql/mysql.sock.
Maybe enven try to get a newer source rpm of mysql and try to install that one. I thought by default that the mysql rpm installs the sock to /lib/var/mysql/mysql.sock..

I had a similar problem with mysql and coldfusion. Rninja

http://www.rninja.com