Cannot install mysql2 on mac os 10.9

Question

I tried

bundle install 

and

 gem install mysql2 

and

 rvm gem install mysql2 

all have the same result below.

 rMBP:scripts admin$ rvm gem install mysql2 Please note that `rvm gem ...` was removed, try `gem install mysql2` or `rvm all do gem install mysql2` instead. ( see: 'rvm usage' ) rMBP:scripts admin$ rvm all do gem install mysql2 Building native extensions. This could take a while... ERROR: Error installing mysql2: ERROR: Failed to build gem native extension. /Users/admin/.rvm/rubies/ruby-2.0.0-p247/bin/ruby extconf.rb checking for rb_thread_blocking_region()... yes checking for rb_wait_for_single_fd()... yes checking for rb_hash_dup()... yes checking for rb_intern3()... yes checking for mysql_query() in -lmysqlclient... no checking for main() in -lm... yes checking for mysql_query() in -lmysqlclient... no checking for main() in -lz... yes checking for mysql_query() in -lmysqlclient... no checking for main() in -lsocket... no checking for mysql_query() in -lmysqlclient... no checking for main() in -lnsl... no checking for mysql_query() in -lmysqlclient... no checking for main() in -lmygcc... no checking for mysql_query() in -lmysqlclient... no *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. Provided configuration options: --with-opt-dir --with-opt-include --without-opt-include=${opt-dir}/include --with-opt-lib --without-opt-lib=${opt-dir}/lib --with-make-prog --without-make-prog --srcdir=. --curdir --ruby=/Users/admin/.rvm/rubies/ruby-2.0.0-p247/bin/ruby --with-mysql-config --without-mysql-config --with-mysql-dir --without-mysql-dir --with-mysql-include --without-mysql-include=${mysql-dir}/include --with-mysql-lib --without-mysql-lib=${mysql-dir}/ --with-mysqlclientlib --without-mysqlclientlib --with-mlib --without-mlib --with-mysqlclientlib --without-mysqlclientlib --with-zlib --without-zlib --with-mysqlclientlib --without-mysqlclientlib --with-socketlib --without-socketlib --with-mysqlclientlib --without-mysqlclientlib --with-nsllib --without-nsllib --with-mysqlclientlib --without-mysqlclientlib --with-mygcclib --without-mygcclib --with-mysqlclientlib --without-mysqlclientlib Gem files will remain installed in /Users/admin/.rvm/gems/ruby-2.0.0-p247/gems/mysql2-0.3.13 for inspection. Results logged to /Users/admin/.rvm/gems/ruby-2.0.0-p247/gems/mysql2-0.3.13/ext/mysql2/gem_make.out rMBP:scripts admin$ 

I have Xcode 5 DP3 and the latest beta version of Maverick 10.9 (13A510d)

Xcode 5 has command line tools built into the application (inside the application package)

Answer 1

First you need to install MySql and I use HomeBrew

 brew install mysql 

if you use 10.9 DP-3, you may fail. But I cheat by changing productVersion to 10.8 in SystemVersion.plist located in / System / Library / CoreServices, and then you can install mysql.

Continue mysql2 installation

 gem install mysql2 

After you have installed all things, you should change productVersion to 10.9.

Answer 2

you need to specify a gem when you can find mysql, the best way is to use mysql_config :

 gem install mysql -- --with-mysql-config=/path/to/mysql/bin/mysql_config 

the path will depend on where you installed mysql.