10.8 upgrade woes - mysql messed up

[jvaska]

I don't recall in the past that an upgrade messed with my AMP setup.

It was easy setting up PHP and Apache again, but now I'm tying to get my previously existing MySQL running again. I can still see it via a MySQL database tool but even after setting the path to /tmp/mysql.sock as it was before it's still not loading.

I really want to preserve all the databases I had (for work and backup purposes).

Has anybody successfully been able to continue using their older MySQL setup after upgradign to 10.8? And, how?

 

[jvaska]

http://blog.tatedavies.com/2012/08/09/new-mac-install-mysql-sock-not-found/

I found the answer - it's YES - thanks to Chris Tate-Davies. The above blog post is the clearest answer I've found for resolving this.

In addition to his quick terminal commands, I also needed to edit the default sock paths in the PHP.ini. The default is /var/mysql/mysql.sock and my setup was using /tmp/mysql.sock. Once I updated and rebooted Apache and MySQL things were good again.