Morshed Alam

Last couple of days ago, I was stuck to install mysql2 gem on windows7 for rails3 and tried lots of instructions by googling. Unfortunately, those were not worked for me.

Finally, I have specified a older version of mysql2 during installation which worked for me. Following are the steps which i did:

• Install Mysql 5.5
• Open command prompt and run following command

  gem install mysql2 --version=0.2.6 --platform=ruby -- '--with-mysql-include="C:Program FilesMySQLMySQL Server 5.5include" --with-mysql-lib="C:Program FilesMySQLMySQL Server 5.5lib"'

• Copy libmysql.dll from C:Program FilesMySQLMySQL Server 5.5lib to [Ruby Installation Directory]bin
• Specify mysql2 version to you gem file
• Run bundle install