Can't install mysql2 gem on Windows 7

I am new to Ruby and have tried and failed several times installing
mysql2 gem on my windows 7 OS. I checked several forums for solutions
but still couldn’t get that installed. can someone help my out please?

below is the error:
c:>gem install mysql2
Building native extensions. This could take a while.
ERROR: Error installing mysql2:
ERROR: Failed to build gem native extension.

checking for rb_thread_blocking_region()… *** 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=C:/Ruby192/bin/ruby
C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:368:in try_do': The complier failed to generate an executable fil e. (RuntimeError) You have to install development tools first. from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:435:intry_link0’
from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:440:in try_link' from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:552:intry_func’
from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:797:in block in have_func' from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:693:inblock in
checking_for’
from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:280:in block (2 levels) in postpone' from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:254:inopen’
from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:280:in block in postpone' from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:254:inopen’
from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:276:in postpone' from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:692:inchecking_for’
from C:/Ruby192/lib/ruby/1.9.1/mkmf.rb:796:in have_func' from extconf.rb:9:in

Gem files will remain installed in
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.2.4 for inspection.
Results logged to
C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.2.4/ext/mysql2/gem_make.out

On Sep 23, 5:03 pm, Robert W. [email protected] wrote:

I am new to Ruby and have tried and failed several times installing
mysql2 gem on my windows 7 OS. I checked several forums for solutions
but still couldn’t get that installed. can someone help my out please?

below is the error:
c:>gem install mysql2
Building native extensions. This could take a while.
ERROR: Error installing mysql2:
ERROR: Failed to build gem native extension.

Please see this:


Luis L.

Luis L. wrote:

On Sep 23, 5:03�pm, Robert W. [email protected] wrote:

I am new to Ruby and have tried and failed several times installing
mysql2 gem on my windows 7 OS. I checked several forums for solutions
but still couldn’t get that installed. can someone help my out please?

below is the error:
c:>gem install mysql2
Building native extensions. �This could take a while.
ERROR: �Error installing mysql2:
� � � � ERROR: Failed to build gem native extension.

Please see this:

Issues · brianmario/mysql2 · GitHub


Luis L.

I just can’t find my way around that post. I renamed the (fstab.sample)
to (fstab) and I edited the file with the following contents.

C:\Ruby192\devkit\mingw\lib\gcc\mingw32\3.4.5
C:\Ruby192\devkit\mingw\libexec\gcc\mingw32\3.4.5

After i tried reinstalling mysql2 but I ended up with the same error
message I posted earlier.

is it something am doing wrong? Am absolutely new to both Ruby and RoR.
Below is the gems i have installed.

*** LOCAL GEMS ***

abstract (1.0.0)
actionmailer (3.0.0)
actionpack (3.0.0)
activemodel (3.0.0)
activerecord (3.0.0)
activeresource (3.0.0)
activesupport (3.0.0)
archive-tar-minitar (0.5.2)
arel (1.0.1)
builder (2.1.2)
bundler (1.0.0)
cgi_multipart_eof_fix (2.5.0)
columnize (0.3.1)
erubis (2.6.6)
fastthread (1.0.1 i386-mswin32)
gem_plugin (0.2.3)
i18n (0.4.1)
linecache (0.43 mswin32)
mail (2.2.6.1)
mime-types (1.16)
minitest (1.7.1, 1.6.0)
mongrel (1.1.5 x86-mswin32-60)
mysql (2.8.1 x86-mingw32, 2.7.3 mswin32)
polyglot (0.3.1)
rack (1.2.1)
rack-mount (0.6.13)
rack-test (0.5.5, 0.5.4)
rails (3.0.0)
railties (3.0.0)
rake (0.8.7)
rdoc (2.5.11, 2.5.8)
ruby-debug-base (0.10.3 mswin32)
ruby-debug-ide (0.4.5)
ruby_core_source (0.1.4)
sqlite3-ruby (1.3.1 x86-mingw32)
thor (0.14.1)
treetop (1.4.8)
tzinfo (0.3.23)

If anybody still facing problem of installing mysql2 gem with rails 3 on
Windows, then refer to the detailed steps of installation on -