Goodbye MySQL (for now)

After always having a terrible time installing MySQL on OS X, today I have given up. I would concede that I have always installed from the Sun/Oracle binary distributions, and always had problems getting everything initialized and situated. 

MySQL has a Preference Pane and some other automated tools that should have made the installation simple. But it wasn't. The Preference Pane failed to start MySQL, and I decided I wasn't going to go down the bug-chasing road. Cryptic error message after cryptic error message wore me out, and that the error messages do not show up on the Mac's Console Log was probably the last straw. 

So, I found some instructions, and removed MySQL. I went to MacPorts and downloaded PostgreSQL and the Python bindings for it. I'll check back in a few days and let you know how it's working. 

UPDATE: 2011-07-14

For months, I haven't been using mysql, preferring to use sqlite when developing with (my new hobby) Django. I finally sorted out my problems, and they come down to the macports install instructions.

###########################################################
# A startup item has been generated that will aid in
# starting mysql5-server with launchd. It is disabled
# by default. Execute the following command to start it,
# and to cause it to launch at startup:
#
# sudo port load mysql5-server
###########################################################
---> Installing mysql5-server @5.1.57_0
******************************************************
* In order to setup the database, you might want to run
* sudo -u _mysql mysql_install_db5
* if this is a new install
******************************************************
---> Activating mysql5-server @5.1.57_0
---> Cleaning mysql5-server

The proper way to get this up and running seems to be to use the following rather than the above:
$ sudo -u mysql mysql_install_db5
Admittedly, I haven't added the launcher, mostly because this is on a laptop. If adding the launcher doesn't work, I may be back with a second update full of correcting past wrongs.