Old Guy New Trick

An old guys journey to learn how to code.

MySQL Issue on Mac OSX

Author: John on October 27, 2014

Most of my Rails projects, for personal use and education, have been using Postgresql or SQLite for the datbase backend.  At work our primary database is Oracle with a dash of MySQL.  Recently we decided to use MySQL with all future development, and migrate our tools/applications that use Oracle to use MySQL.

I downloaded and installed MySQL by grabbing the installer from the MySQL website:  http://dev.mysql.com/downloads/mysql/ and getting the version for my operating system - OS X Mavericks.

However, with this version installed I was having issues with bundler and getting the mysql gem to compile.  I tried a few solutions that I found on the internet, but none of them were working.

I found some other people who had issues, when using OSX Mavericks, with the MySQL installer.  They solved the issue by removing MySQL that was installed from the download via dev.mysql.com and then re-installing using Homebrew.

This solution worked for me as well.  I found this a bit odd, because earlier in the year I had issues with installing Postgres via Homebrew.  The solution for Postgres was to remove the Homebrew installation and use the installer from the Postgres site.

Learn Something New Every Day

Last Edited by: John on November 11, 2015