MySQL gem installation with windows 7 64 bits

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.