Welcome to the MacNN Forums.

DemersDesigns · Apr 1, 2006, 08:16 AM

Hey

I am having issues with PHP and MySQL on my Mac OS/X client machine, I have MySQL 5.0 GA installed the Apache 1.3 and PHP4 installed (and enabled) that came with Mac OS/X Tiger.

MySQL works fine when I connect using something like Navicat, and PHP works fine until I try and connect to a database when I then get an error "Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)".

I created a my.cnf in /usr/local/mysql/data by copying it from the mysql/support-files/my-small.cnf and sure enough the socket is pointed at /tmp/mysql.sock. I have tried editing that to /var/mysql/mysql.sock but mysql wouldnt start then

Not good...

Does anyone know how I can make apache/php look for /tmp/mysql.sock instead of /var/mysql/mysql.sock?

Thanks
Dave

Rainy Day · May 1, 2006, 02:55 AM

In Terminal.app try: sudo ln -s /private/tmp/ /private/var/mysql

DemersDesigns · May 1, 2006, 03:15 AM

Thanks for the reply, I managed to solve it with the same command.

I blogged it here if thats useful to anyone:
http://macnewbie.wordpress.com/2006/...socket-gotcha/
and more details on this solution:
http://macnewbie.wordpress.com/2006/...tiger-the-fix/