10.4.4 MySQL Issue

After upgrading to Mac OS X 10.4.4, I have some problem with MySQL 5.0.



It seems runnable but all of my CMS (Drupal, phpMyAdmin) can't connect to database server. After googling around, this is caused by socket location problem. 10.4.4 PHP is pointed to /var/mysql/mysql.sock while default MySQL configuration is /etc/mysql.sock.



This is long known bug of Mac OS X 10.4 series. I still don't understand why it just happens on my 10.4.4 but not 10.4.3.



Anyway, the solution is creating /etc/my.cnf with these line:

[mysqld]

socket=/var/mysql/mysql.sock

Don't forget to set permission of /var/mysql to 775.



Launching MySQL daemon from Preferences (in case you installed MySQL Preferences too) still show "stop" state but it is actually running and works fine.



This discovery begin by I want to test K2 Drupal port by my friend, iChris.



P.S. My furthure advice is a simple php file with only one line:

<?php phpinfo(); ?>

is extremely useful for debugging.