I recently jumped through a bunch of hoops getting Apache, PHP and MySQL running on my Lion Macbook Pro, including doing an install of MySQL that "didn't work". I believe(d) I removed all the installed files before doing a successful install, but when I look at Activity Monitor it either shows two instances of mysqld running, or one instance and the MySQL preference pane shows the server as "stopped", and attempts to start it fail. I have to kill the running instance in Activity Monitor and then I can start it using the preference pane, and everything works.
I'm trying to figure out where this other instance of MySQL lives, and how I can remove or disable it so I don't have to keep jumping thru these hoops every time.
My first install was following the instructions on this page (skip down a bit to the MySQL install bit):
https://discussions.apple.com/thread/3216810?start=0&tstart=0
Could that launchd config file be the problem? Is it starting up a version of mysqld too?
After following these instructions to uninstall MySQL:
http://stackoverflow.com/questions/1436425/how-do-you-uninstall-mysql-from-mac-os-x
My second (successful) installation was just downloading the installer and running it, and running the startup item installer and adding the preference pane. I still recall having to work on some socket paths - in php.ini I believe - to get it all running.
It all works fine now as long as I kill the extra instance in Activity Monitor, but it's bothersome to have to remember to do this every time I restart my machine.
Any tips/advice?
Thanks!