Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the '10.4: Repair PHP/MySQL connections in 10.4.4' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
10.4: Repair PHP/MySQL connections in 10.4.4
Authored by: Globulator on Feb 03, '06 01:35:52AM

The reason you must not use /tmp/mysql.sock is that any Tom, Dick or Other can simply delete it and bring your php-mysql system down.

The fix is actually simple:
sudo mkdir -p /var/mysql
sudo chgrp mysql /var/mysql
sudo chmog g+w /var/mysql

edit/create /private/etc/my.cnf and add the line:
socket=/var/mysql/mysql.sock

restart mysql

now the new php wil find the socket info in the right place, if you change php then you might need to tell that about the new secure location.



[ Reply to This | # ]