title: Ruby MYSQL2 gem installation on windows 8.1
body: <p>I've spent a lot of time to fix this. Everytime I run this command</p>
  
  <blockquote>
    <p>gem install mysql2 --version 4.0.0 --no-ri --no-rdoc</p>
  </blockquote>
  
  <p>I get the error message ( Ruby 200)</p>
  
  <pre><code>&gt;gem install mysql2 --no-rdoc --no-ri
  </code></pre>
  
  <p>Temporarily enhancing PATH to include DevKit...
  Building native extensions.  This could take a while...
  ERROR:  Error installing mysql2:
          ERROR: Failed to build gem native extension.</p>
  
  <pre><code>C:/Ruby200/bin/ruby.exe -r ./siteconf20141018-57844-88i3bz.rb extconf.rb
  checking for ruby/thread.h... yes
  checking for rb_thread_call_without_gvl() in ruby/thread.h... yes
  checking for rb_thread_blocking_region()... yes
  checking for rb_wait_for_single_fd()... yes
  checking for rb_hash_dup()... yes
  checking for rb_intern3()... yes
  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... no
  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... no
  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=C:/Ruby200/bin/ruby
      --with-mysql-dir
      --without-mysql-dir
      --with-mysql-include
      --without-mysql-include=${mysql-dir}/include
      --with-mysql-lib
      --without-mysql-lib=${mysql-dir}/
      --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}/
      --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
  
   extconf failed, exit code 1
  
  Gem files will remain installed in C:/Ruby200/lib/ruby/gems/2.0.0/gems/mysql2-0.
  3.16 for inspection.
  Results logged to C:/Ruby200/lib/ruby/gems/2.0.0/extensions/x86-mingw32/2.0.0/my
  sql2-0.3.16/gem_make.out
  </code></pre>
  
  <p>I have copied the .dll file from Mysql to bin directory of Ruby folder
  I also updted the command </p>
  
  <pre><code>gem install mysql2 --no-rdoc --no-ri -- '--with-mysql-lib="C:\Program Files\MySQL/MySQL Server 5.6\lib\" --with-mysql-include="C:\Program Files\MySQL\MySQL Server 5.6\include"'
  </code></pre>
  
  <p>I need help please</p>