gem install mysql failure in Snow Leopard

0 votes
asked Sep 2, 2009 by collimarco

I successfully installed MySql x86_64 in Snow Leopard and Ruby and Ruby Gems seems to be installed properly:

$ which mysql
$ which ruby
$ which gem
$ mysql
Your MySQL connection id is 404
Server version: 5.1.37 MySQL Community Server (GPL)
$ ruby -v
ruby 1.8.7 (2008-08-11 patchlevel 72) [universal-darwin10.0]
$ gem -v

Unfortunatly I get an error installing mysql gem:

$ sudo gem update --system
$ sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
Building native extensions.  This could take a while...
ERROR:  Error installing mysql:
    ERROR: Failed to build gem native extension.

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby extconf.rb --with-mysql-config=/usr/local/mysql/bin/mysql_config
mkmf.rb can't find header files for ruby at /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ruby.h

Gem files will remain installed in /Library/Ruby/Gems/1.8/gems/mysql-2.8.1 for inspection.

6 Answers

0 votes
answered Sep 2, 2009 by jan-gorman

I think you should try to uninstall the old mysql gem first before recompiling

sudo gem uninstall mysql
sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
0 votes
answered Sep 2, 2009 by collimarco

Installing the Xcode that's bundled with the Snow Leopard fixed the problem.

0 votes
answered Sep 9, 2010 by rxgx

If you've installed MySQL 5 using MacPorts, then use the command:

sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/opt/local/bin/mysql_config5
0 votes
answered Sep 28, 2010 by craig

For me, it was adding the UNIX Tools option (if I recalled the name accurately), which include the headers. When I installed XCode originally, I didn't include this component because I didn't think that I would be writing UNIX code. Little did I know...

0 votes
answered Sep 18, 2011 by chris

I had this problem when I updated to Lion. In this case, I when to the app store and downloaded the latest Xcode. Then I uninstalled and reinstalled the database.

The issue had to do with a broken link during the update. Ruby likes to be in /System while Apple places ruby in /Developer.

0 votes
answered Sep 15, 2017 by punj

was stuck with same problem: Tried most of the solution's: At the end

Edit the app/config/database.yml, change the adapter to mysql2

  adapter: mysql2
  database: commissi_production
  username: root
  password: root
  host: localhost

& run on terminal

 gem install activerecord-mysql2-adapter

Solved the problem.

Welcome to Q&A, where you can ask questions and receive answers from other members of the community.
Website Online Counter