I have installed MySQL. I have switched the socket file to /tmp/mysql.sock. When I issue the command: mysql -u root -p mysql, and after typing pw, I get the following:

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

Very strange. Mysqld is running as mysql. I have correct permissions on the directories:
mysql:/ > ll -d /tmp
drwxrwxrwt 13 root root 4096 2007-11-09 02:00 /tmp
root:~ > ll /tmp/mysql.lock
srwxrwxrwx 1 mysql mysql 0 Nov 9 02:02 /tmp/mysql.lock

user mysql is in group mysql and the server is running.

Not sure at all why this is happening. When I connect to the server like this: mysql -u root -h 127.0.0.1 -p mysql, then it works.

What is going on here? Does someone know the issue? I have never ran into this before....

Thanks...

Hi,

The file in /tmp is called mysql.lock is that correct? Shouldn't that be mysql.sock? You can give it (mysql.sock) any name you want, but it should be consistent. Check your /etc/my.cnf to see if all(!) socket entries are set correctly.

Hope this helps.

Thanks for noticing that! It usually always is something so simple it is looked over. I did have the wrong name of the sock file.

Thanks....