gem install mysql2 failed on on Ubuntu 14.04

Posted September 10, 2014 34.1k views
~# gem install mysql2
Building native extensions.  This could take a while...
ERROR:  Error installing mysql2:
        ERROR: Failed to build gem native extension.

    /usr/local/rvm/rubies/ruby-2.0.0-p353/bin/ruby extconf.rb

Gem files will remain installed in /usr/local/rvm/gems/ruby-2.0.0-p353/gems/mysql2-0.3.16 for inspection.

I google and tried the below but still the same error. Pleas help! Thank you!

sudo apt-get install mysql-client libmysqlclient-dev


These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
6 answers

It looks like you are probably missing something needed to compile the mysql2 gem’s C extension. Try installing the following packages:

sudo apt-get install build-essential libmysqlclient-dev

sudo apt-get install mysql-server libmysqlclient-dev

Works for me.

Hi wavrin, asb, thanks for your answer. However, I still have the same error after running your commands.

would appreciate if anyone can give suggestion on how to setup mysql2 on Ubuntu 14.04. It is a new droplet that i just created yesterday.

I guess you can reproduce this by creating a new temporary droplet Ubuntu 14.04 with ruby and rails

Also need to install ruby2.*-dev

sudo apt-get install build-essential libmysqlclient-dev

works for me! thanks