Install MySql on Mac OSX

Extracted from this article

1. Download MySql dmg from official site

2. Install all packages

3. In system preference, make sure the mysql is up and running

4. Change root password => mysqladmin -u root -p’OLDPASSWORD’ password NEWPASSWORD

5. Set up command line and manual pages:

echo 'export PATH=/usr/local/mysql/bin:$PATH' >> ~/.profile

echo 'export MANPATH=/usr/local/mysql/man:$MANPATH' >> ~/.profile

(For Rails Developers:)
6. If you are migrated from Leopard to Snow Leopard, you need to reinstall snow leopard version XCode to get rid of gem update errors (caused by missing ruby.h header file)