This is a recent problem... MySQL was working and a couple of days ago I must have done something. I deleted MySQL and tried reinstalling using the .dmg file. The mysql.sock file never gets created and I get the following error messages:
Hristo$ mysql Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
I also tried stopping Apache and installing but Apache gave me an error... I don't know if this is good or bad:
Hristo$ sudo apachectl stop launchctl: Error unloading: org.apache.httpd
I tried the MacPorts installation as well but the socket file still didn't get created. I don't really know what to do and I don't want to reinstall Snow Leopard and start from scratch :/
I also tried installing the 32-bit version and same deal. No luck.
Finally... I tried doing the source installation but when I get to the configuration step, I get the following error:
-bash: ./configure: No such file or directory
The file is "mysql-5.1.47-osx10.6-x86_64.tar.gz" so I think it is the proper file for source installation and yes I have a 64 bit system. I don't know what to do anymore.