Newbie | Installing mysql2 gem

Hello everyone,
I wanted to learn about Ruby on Rails and its advantages and I decided
to start with some tutorials.
Unfortunately I'm forced to post my problem on the forum after days of
unsuccessful solutions.
I've installed Railsinstaller and mysql 5.5.15 64 bit version.
I'm running win 7. I've been using the following command:

C:\>gem install mysql2 -- --with-mysql-lib=C:\MySQL\lib
--with-mysql-include=C:\MySQL\include

I've used this command and included path for Mysql 32 bit (lib, include
directories) but I constantly get the following error:

C:/RailsInstaller/Ruby1.9.2/bin/ruby.exe extconf.rb
--with-mysql-lib=C:\MySQL\lib --with-mysql-include=C:\MySQL\include
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.

For what I understand it might be having problems finding the right
library for the install.
Any help is warmly appreciated. I've manage to create a working
application with SQLite, but I honestly prefer to use Mysql.

Thank you all!

I am successfully using mysql with rails...Do the following

1. edit Gemfile => gem 'mysql2', '0.2.6'
     2. download mysql-noinstall-5.1.50-win32.zip at
http://downloads.mysql.com/archives/mysql-5.1/mysql-noinstall-5.1.50-
,unzip
     3. gem install mysql2 -v 0.2.6 – --with-mysql-lib=E:\ROR
\mysql-5.1.50-win32\lib --with-mysql-include=E:\ROR\mysql-5.1.50-
win32\include (replace the file "E:\ROR\mysql-5.1.50-win32" path
with
yours)
     4. this should work now,try bundle install,generate some
model ,and run rake db:migrate to see if it works,make sure your
database config is right,like this
development:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: depot_development
  pool: 5
  username: root
  password: root
  host: localhost
   5.if it still not work ,try this => https://github.com/brianmario/mysql2/issues/8
Hope this helped

http://blog.mmediasys.com/2011/07/07/installing-mysql-on-windows-7-x64-and-using-ruby-with-it/

You can't link 32bits Ruby against 64bits MySQL.

then download the 64 bit version...