Installing MySQL on OSX Lion

Setting up your dev environment can be a b*itch-and-a-half.  There are dozens of StackExchange articles about installing each tool/framework, but people change their setup so frequently that it's hard to tell which dependencies they have that you don't.  For my own benefit, I've decided to document how I set up my own system after a clean install of Mac OSX Lion, so all dependencies are accurately captured.  Hope this is of use to someone else as well.

Quick tips to set up MySQL on your intel Mac OSX Lion machine

• Download the MySQL .dmg file here
• Within the .dmg file:
• Run the large MySQL .pkg file
• Run the MySQLStartupItem.pkg file
• Run MySQL.pref_Pane
• Active MySQL server
• If you don't want to deal with this again, select the option to automatically start MySQL when your computer boots

Now, run the following commands in terminal

• Add mysql to your PATH
• Run 'sudo nano -S /etc/profile'
• Add the line 'export PATH=$PATH:/usr/local/mysql/bin' and save changes
• Open a new Terminal window for changes to take effect
• Enable a root password for your DB
• Run 'mysqladmin -u root password', where 'password' is your secure DB password.
• Run 'mysql -u root -p'.  You should now have command-line access to your local MySQL DB.