OK, I admit it, I love OSX, but I don't care for any versions after 10.6.8 because they are so idiotic and iOS-like. This can cause problems if you need the latest software, since so many versions require more recent versions of the OS.
I recently needed to use MYSQL 5.6, and not finding any 10.6 binaries available, decided to compile my own from source.
Prior to doing this, be sure the have the following installed:
Xcode 4.2 for OSX 10.6 (this contains gcc) Macports
Using macports, install git and cmake
Download the sources from the MySQL/Oracle website:
Select "MySQL Community Server 5.6" (as of this writing this will contain version 5.6.29. Note I was not able to get this working with version 5.7)
and then download "Generic Linux (Architecture Independent), Compressed TAR Archive"
Unpackage the archive, then:
$ cd mysql-5.6.29 $ cmake . $ make $ sudo su # make install
the make install will install the binaries into /usr/local/mysql perform all the next steps as root:
# cd /usr/local/mysql # chown -R mysql . # chgrp -R mysql . # scripts/mysql_install_db --user=mysql # chown -R root . # chown -R mysql data
At this point, you are pretty much done. To start mysqld run the following:
# /usr/local/mysql/bin/mysqld_safe --user=mysql &
Then set a password for the mysql "root" user. (Totally different from the unix root user. The mysql root is like Oracle's sys user)