Category:Technology -> Adventures with the naked Mac Mini Server -> Install MySQL on Lion
Install the MySQL database server
Unlike previous versions of OS X Server, the OS X 10.7.x Lion Server distribution does not include the MySQL database server. Instead the PostgreSQL database server is included. If you’re like me, most of your databases will be in MySQL and you probably won’t want to migrate from MySQL to PostgreSQL. Use these steps to install the current version of the MySQL database server:
- Download the Disk Image distribution of the current version of the 64-bit version of MySQL. The current MySQL version at the time of this writing is 5.5.16 and is labeled for Mac OS X 10.6 Snow Leopard. It works fine with Mac OS X 10.7.x Lion.
- Install the Disk Image distribution of the current version of MySQL.
- Add /usr/local/mysql/bin to your path by editing the ~/.bash_profile file in your home directory with your favorite text editor.
- Add the following to the .bash_profile file: export PATH=~/bin:/usr/local/bin:/usr/local/mysql/bin:$PATH
- export EDITOR=vim and save the .profile file.
- Log out of your terminal session, open a new terminal session, and enter: echo $PATH.
- Install the MySQLStartupItem.pkg.
- Double-click the MySQL.prefPane file to install the MySQL preferences pane in your System Preferences.
- Check the Automatically Start MySQL Server on Startup checkbox.
