Quote

Hi Charlie,

I had the same problem on both Tiger and Leopard. It seems that the newer mysql builds have moved
some of the libraries and the config files haven't caught up.

The article/blog that helped me is:

http://jayallen.org/journey/2006/04/dbd-mysql-buil...

The simplest solution for me is towards the end in the comments mentioning creating links
from where it thinks it should be to the new location, the solution that I used.
ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql

ln -s /usr/local/mysql/include /usr/local/mysql/include/mysql

(use sudo as needed)

imac24:~ root# ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql
ln: /usr/local/mysql/lib/mysql/lib: File exists
imac24:~ root# ln -s /usr/local/mysql/include /usr/local/mysql/include/mysql
ln: /usr/local/mysql/include/mysql/include: File exists
imac24:~ root# perl -MCPAN -e 'install DBD::mysql'

imac24:bin root# ./mysql_config --libs
-L/usr/local/mysql-5.0.51b-osx10.4-i686/lib/mysql -lmysqlclient -lz -lm

mysql-5.0.67-osx10.5-x86.dmg

PATH=$PATH:/usr/local/mysql/bin
export PATH

imac24:~ root# perl -MCPAN -e 'force install DBD::mysql'

Quote

PHP in Leopard (OS X 10.5) looks for the socket at /var/mysql/mysql.sock

The MySQL 5.0.45 installer by makes a socket at /tmp/mysql.sock

sudo mkdir /var/mysql
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
sudo chown _mysql /var/mysql/mysql.sock
sudo chmod 777 /var/mysql/mysql.sock

Then my old PHP code works with MySQL.