error during installing gem named mysql2

hello everyone,

***im getting this error when im installing a gem via command prompt ***

can any one help me out? please

thanks.

C:>gem i mysql2

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.***

*** C:/Ruby192/bin/ruby.exe extconf.rb***

checking for rb_thread_blocking_region()… yes

checking for main() in -llibmysql… 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:/Ruby192/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}/lib***

*** --with-libmysqllib***

*** --without-libmysqllib***

Gem files will remain installed in C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.

2.6 for inspection.

Results logged to C:/Ruby192/lib/ruby/gems/1.9.1/gems/mysql2-0.2.6/ext/mysql2/ge

m_make.out

i even tried installing gem mysql2 but im getting a error which i’m nt able to retify it… following is the error

C:>gem i mysql2

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.***

*** C:/Ruby192/bin/ruby.exe extconf.rb***

checking for rb_thread_blocking_region()… yes

checking for main() in -llibmysql… 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:/Ruby192/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}/lib***

*** --with-libmysqllib***

*** --without-libmysqllib***

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/ge

m_make.out

Try to build it with native extensions…

gem install mysql2 --platform=ruby

B.

thanks sir. it worked…