MySQL gem installation with windows 7 64 bits

[vinayk...@bitlasoft.com]

ruby 2.0.0 + windows 7 + mysql 5

    bundle install

GemFile

    gem "mysql2", "~> 0.3.17"

while installing bundle in rails project i am getting this error. i am having windows system (64 bits OS).

How can i resolve this error?

Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension.

    

        C:/RailsInstaller/Ruby2.0.0/bin/ruby.exe 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:/RailsInstaller/Ruby2.0.0/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

    

    

    Gem files will remain installed in C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/mysql2-0.3.15 for inspection.

    Results logged to C:/RailsInstaller/Ruby2.0.0/lib/ruby/gems/2.0.0/gems/mysql2-0.3.15/ext/mysql2/gem_make.out

    An error occurred while installing mysql2 (0.3.15), and Bundler cannot continue.

    Make sure that `gem install mysql2 -v '0.3.15'` succeeds before bundling.