Newbie | Installing mysql2 gem

Rails
1

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!

2

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
3

On 8 sep, 11:32, Diego W. [email protected] wrote:

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.

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.

–
Luis L.

4

then download the 64 bit version…