How to install MySQL gem on Mac OS X

Question

What do I need to install mysql gem on Mac OS X ? I'm getting error "failed to build native extensions".

Glorfindel · Accepted Answer · 2021-08-16 05:45:25Z

20

Install MySQL first, either by using binary or Homebrew.

Then:

gem install mysql2

Or:

gem install ruby-mysql

Just pick one and you are good to go.

Edit

In case you upgraded to MySQL version 5.6.12 on OS X, mysql2 will fail to compile. Solution is to downgrade MySQL as described here: https://stackoverflow.com/a/17252887/45254

Edit2

In case you don't want to have mysql installed (maybe you use docker to manage your services) but do want to use mysql2 gem, you can instead install mysql-connector-c (using homebrew).

edited Aug 16, 2021 at 5:45

Glorfindel

22.8k13 gold badges97 silver badges124 bronze badges

answered Feb 11, 2011 at 8:05

Krule

6,4963 gold badges36 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Pierre-Gilles Levallois Over a year ago

to install mssql with homebrew, type command : "brew install mysql".

lesyk Over a year ago

In case if you have problems with mysql from mac ports run: gem install mysql2 -- --with-mysql-config=/opt/local/lib/mysql?/bin/mysql_config

tessie Over a year ago

you don't want to downgrade mysql5. in Mysql8 caching_sha2_password is the default caching mechanism. if the client library does not support caching_sha2_password you can change mysql authentication mechanism to sha256_password like stackoverflow.com/questions/49948350/phpmyadmin-on-mysql-8-0

Theo · Accepted Answer · 2011-02-11 08:24:23Z

Some time back I wrote some instructions on my blog on how to do it in 10.6, but I think it's the same in 10.5.

I comes down to this command:

ARCHFLAGS="-arch x86_64" gem install mysql -- \ --with-mysql-config=/path/to/mysql_config

but you need to find the real value for /path/to/mysql_config. My blog post has a few tips, but there's one very important thing: you must have installed MySQL with headers. The official .pkg installer from MySQL doesn't IIRC. The best thing to do is to install MySQL with Homebrew (in the post I use examples from a MacPorts install, but that's because Homebrew wasn't mature when I wrote it).

If you install MySQL with Homebrew mysql_config will be located at /usr/local/bin/mysql_config and if you install it with MacPorts it will be at /opt/local/lib/mysql5/bin/mysql_config.

I concur with the other answer that suggest that you install the mysql2 gem instead of mysql. I think the command above should work for mysql2 too.

Matteo Alessani · Accepted Answer · 2013-12-17 20:04:40Z

if you already have MySQL server running elsewhere on the network and would like to still install the gem without having to install MySQL try the following

brew install mysql-connector-c

followed by

gem install mysql

JB Hewitt · Accepted Answer · 2011-11-21 01:30:41Z

I'm running Mac OS X Lion with Homebrew.

The correct command to install a ruby gem is…

gem install mysql -- \ --with-mysql-config=/usr/local/bin/mysql_config

avillagran · Accepted Answer · 2012-11-26 23:08:30Z

I'm using Mac OS X Mountain Lion, and installed MySQL with DMG.

gem install do_mysql -- \ --with-mysql-dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib --with-mysql-include=/usr/local/mysql/include

and

sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib

This works for me ;)

codener · Accepted Answer · 2014-01-03 13:59:02Z

4

For me it did the most easy:

brew install mysql gem install mysql

Brew is a package manager for Mac OS, a must have. Using it to install mysql first brings everything that the gem command is missing.

answered Jan 3, 2014 at 13:59

codener

4861 gold badge10 silver badges29 bronze badges

1 Comment

Ed Halferty Over a year ago

Worked for me on 10.10. This is much better than the accepted answer. mysql2 is not better than mysql if you need prepared statements. See: stackoverflow.com/a/21726231/1143830

tirdadc · Accepted Answer · 2019-01-11 04:57:25Z

4

I installed MySQL with Homebrew and I had to use this to finally be able to upgrade the gem:

gem install mysql2 -- --with-mysql-dir=/usr/local/opt/mysql/

answered Jan 11, 2019 at 4:57

tirdadc

4,7133 gold badges40 silver badges47 bronze badges

2 Comments

Mason SB Over a year ago

This helped me but I had to use the directory of where mysql was. For me it was opt/homebrew/opt/mysql ...

Alexander Dischberg Over a year ago

was working on an old project and need to use specific version of mysql. mine was gem install mysql2 -- --with-mysql-dir=/usr/local/opt/[email protected]/

Maciel Escudero Bombonato · Accepted Answer · 2015-04-28 16:34:35Z

I'm using Mac OS X 10.10 (Yosemite), and to me worked with the command bellow:

gem install mysql2 -- \ --with-mysql-config=/usr/local/mysql/bin/mysql_config

chown · Accepted Answer · 2011-11-08 20:34:42Z

I install MySQL with DWG mysql_config will be located at /usr/local/mysql/bin/mysql_config

gem install mysql -- \ --with mysql-config=/usr/local/mysql/bin/mysql_config

tessie · Accepted Answer · 2018-11-29 10:49:52Z

I came across this issue while setting up MySQL gem on MacOs Mojave .This worked for me

1 Ensure Xcode command line tools are installed. xcode-select --install

For me the build was still failing with some header files missing which you have to install open /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg

This link pointed to right direction. Can't compile C program on a Mac after upgrade to Mojave

Collectives™ on Stack Overflow

How to install MySQL gem on Mac OS X

10 Answers 10

3 Comments

1 Comment

Comments

Comments

Comments

1 Comment

2 Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

3 Comments

1 Comment

Comments

Comments

Comments

1 Comment

2 Comments

Comments

Comments

Comments

Linked

Related