# Error to gem install mysql

**URL:** <https://www.ruby-forum.com/t/error-to-gem-install-mysql/187516>\
**Category:** Ruby\
**Created:** [April 24, 2010, 3:37pm UTC](https://www.ruby-forum.com/t/error-to-gem-install-mysql/187516 "2010-04-24T15:37:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![luofeiyu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/9de0a6/32.png) [@luofeiyu](https://www.ruby-forum.com/u/luofeiyu)\
**Post date:** [April 24, 2010, 3:37pm UTC](https://www.ruby-forum.com/t/error-to-gem-install-mysql/187516/1 "2010-04-24T15:37:35Z")

</div>

in my console:  
pt@pt-laptop:~$ sudo gem install mysql  
[sudo] password for pt:  
Building native extensions. This could take a while…  
ERROR: Error installing mysql:  
ERROR: Failed to build gem native extension.

/usr/local/ruby/bin/ruby extconf.rb  
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… yes  
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  
–without-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=/usr/local/ruby/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}/lib  
–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  
/usr/local/ruby/lib/ruby/gems/1.9.1/gems/mysql-2.8.1 for inspection.  
Results logged to  
/usr/local/ruby/lib/ruby/gems/1.9.1/gems/mysql-2.8.1/ext/mysql\_api/gem\_make.out

how can i do?  
think you in advance.

---

<div class="post-metadata">

**Author:** ![luofeiyu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/9de0a6/32.png) [@luofeiyu](https://www.ruby-forum.com/u/luofeiyu)\
**Post date:** [April 24, 2010, 4:13pm UTC](https://www.ruby-forum.com/t/error-to-gem-install-mysql/187516/2 "2010-04-24T16:13:01Z")

</div>

Pen T. wrote:

> how can i do?

Likely you are missing mysql client development libraries. How to fix  
this depends on what platform you are on.

e.g. for ubuntu Linux it’s usually  
[sudo] apt-get install libmysqlclient-dev

(or libmysqlclient15-dev or libmysqlclient16-dev to force a particular  
version)
