Newbie | Installing mysql2 gem

rubyonrails-talk
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

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.

4

then download the 64 bit version...