Fix mySql for OSX 10.7 Lion

I’ve just updated my Mac to Lion. Didn’t do anything fancy just hit the link in the Mac App Store. All was good with my Apache set up apart from mySql wasn’t working as expected.

After a bit of digging around I found the culprit (spelling is good on Lion). The php.ini file has been modified.

Head to your etc folder

cmd shift G “/etc” (in the finder).

open php.ini.default in a text editor that has admin rights. I use TextMate. Do a search for ‘mysql.sock’ replace the default path ‘/var/mysql/mysqlysql.sock’ with ‘/tmp/mysql.sock’.

Save this file as ‘php.ini’. You will be asked for your password as your editing a system file.

Give the server a restart.

Terminal: sudo apachectl graceful

All should now be good. Worked for me.