Monthly Archives: May 2012

Installing MySQL 5 on Tiger OS X 10.4 with MacPorts

sudo port install mysql5sudo port install mysql5-serversudo port install mysql5-devel

sudo -u mysql mysql_install_db5

/opt/local/lib/mysql5/bin/mysql_secure_installation

To Start/Stop MySQL 5 Server with Launch Daemon use the following commands:sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plistsudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist

Note: /Library/LaunchDaemoins/org.macports.mysql5.plist symlink is installed by the port package from /opt/local/etc/LaunchDaemons/org.macports.mysql5.

You can start the server with sudo port load mysql5-server and stop it with sudo port unload mysql5-serverYou can start the MySQL daemon with:cd /opt/local ; /opt/local/lib/mysql5/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd /opt/local/mysql-test ; perl mysql-test-run.pl