Sam Pierson's Blog

Remove mysql, prefpane item, startup item.
then:

sudo rm -rf /Library/Receipts/mysql*

There is a good complete explanation of this here.

To start, stop and disable mysql server from the command line:

# start
sudo launchctl start com.mysql.mysqld
# stop
sudo launchctl stop com.mysql.mysqld
# Unload
sudo launchctl unload /Library/LaunchDaemons/com.mysql.mysqld.plist

Thanks to this post, I discovered how to install the MySQL ruby gem on Mac OS X:
You must be using the x86 variant of MySQL, not x86_64, apparently.  Then:

sudo env ARCHFLAGS="-arch i386" gem install mysql — \
–with-mysql-dir=/usr/local/mysql –with-mysql-lib=/usr/local/mysql/lib \
–with-mysql-include=/usr/local/mysql/include

To get SchemaSpy working on Mac OS X, I:
Downloaded the latest SchemaSpy, schemaSpy_4.0.0.jar
Installed GraphViz using MacPorts

sudo port install graphviz

Installed the MySQL JDBC drivers using MacPorts

sudo port install mysql-connector-java

Ran it like this:

java -jar schemaSpy_4.0.0.jar -t mysql -dp /opt/local/var/macports/software/mysql-connector-java/5.0.7_0/opt/local/share/java/mysql-connector-java-5.0.jar -o <outputdir> -host localhost -db <dbname> -u <username> -p <password>

If you installed the MySQLStartupItem that comes with mysql.com’s binary packaged MySQL server, you can:

sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

to start the server.  This applies to Leopard.  Apparently under Tiger it had a different name.

There are a couple of possible ways to install MySQL server on Mac OS X Leopard. Which one you take depends on what is available at mysql.com. When a new version of Mac OS come out, in the past it has taken mysql.com many months to come up with packaged binary releases of MySQL server [...]

Download latest phpMyAdmin.
In an appropriate website content folder (e.g. /Library/WebServer/Documents/ on Mac OS X):

tar xvf ~/phpMyAdmin-2.11.8.1-english.tar.bz2
ln -s phpMyAdmin-2.11.8.1-english phpmyadmin
cd phpmyadmin
cp config.sample.inc.php config.inc.php

Edit config.inc.php and set your blowfish secret to a random string:

$cfg[’blowfish_secret’] = ‘ertyrtfghrty’;

On Mac OS X Leopard, there appears to be an issue with PHP that you have to resolve by changing localhost to [...]

The version of MySQL that comes preintsalled on MacOS X (Leopard) Server does not include client libraries and header files, as discussed here.  The remedy as discussed here is to:
Download MySQL-43.binaries.tar.gz
Stop MySQL Server if it was running (Server Admin -> MySQL -> Stop MySQL)

tar xvfz MySQL-43.binaries.tar.gz
cd MySQL-43.binaries
sudo tar -xzvf MySQL-43.root.tar.gz -C /

To configure and start MySQL:
Using Server Admin
Servername -> Services -> [...]