Install the mysql2 gem for a specific mysql client version?

Question

I'm trying to use the mysql2 gem with rails 3.1.0.rc6, but I'm having some problem with my mysql client.

I'm getting this message when trying to start my server.

Incorrect MySQL client library version! This gem was compiled for 5.1.53 but the client library is 5.5.14. (RuntimeError)

How do I compile/install mysql2 so that is can use mysql 5.5.14?

I've tried using gem pristine mysql2 without success.

score 12 · Accepted Answer · edited Oct 07 '21 at 05:45

12

The problem here was that the MySQL2 gem was compiled for the MySQL version installed by Apple (Development package) not by me using Homebrew.

Using this command when installing the gem solved the problem.

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

Don't forget to install mysql using:

sudo brew install mysql

The problem now is that we somehow need to pass the option to bundler, to do that you can use bundler config.

bundle config build.mysql2 --with-mysql-config=/usr/local/Cellar/mysql/5.5.14/bin/mysql_config

Running bundle install in your ruby app should now work.

edited Oct 07 '21 at 05:45

Glorfindel

answered Aug 31 '11 at 10:04

Linus Oleander

1

bundle config command didn't work for me (brew mysql didn't install so install alternative version) on lion. gem pristine mysql2 actually solved it somehow! :) – Daniel Morris Jul 02 '12 at 00:25
This answer worked for me, however I had to perform one extra step not mentioned in the answer. When I tried to do `brew install mysql` i got the following error `Error: mysql-5.5.19 already installed To install this version, first 'brew unlink mysql'`, so I ran this: `brew unlink mysql` before `brew install mysql` and then the rest of the steps in the answer worked and solved my problem. – Livi17 Oct 07 '14 at 23:22

score 0 · Answer 2 · answered Apr 17 '19 at 15:59

0

What worked for me in a similar situation:

brew reinstall mysql
gem pristine mysql2

answered Apr 17 '19 at 15:59

bluemihai

score 0 · Answer 3 · answered Aug 22 '11 at 10:12

Looks like unmatched version with mysql client library and mysql2 compiled gem give LoadError.

So, they explictly raise RuntimeError for that

So, only the way I aware is, download the source from github and compile it in your machine.

3 Answers3