Hi Folks,
In this short tutorial of mine, I am going to write down the steps of how you can install mysql2 gem with Ruby2.0 on Windows machine.
Installing Mysql gem is always a big time pain for most of the developers who are working on Windows machine. But thanks to active folks over the internet for their comments, posts.
Prerequisites:
1. Ruby 2.0.0 pre-installed.
2. DevKit installed
3. gem install rails – command should install all the gems. Return should be success.
Steps to install mysql gem:
1. Go to: http://dev.mysql.com/get/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip/from/pick, download will start automatically (don’t think at this moment that you’ve a 32 bit or 64 bit operating system.
2. Extract the folder to some place (in my case I am extracting it to C:\mysql-connector-c-noinstall-6.0.2
3. Run this command:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
gem install mysql2 –platform=ruby — '–with-mysql-include=C:\mysql-connector-c-noinstall-6.0.2\include –with-mysql-lib=C:\mysql-connector-c-noinstall-6.0.2\lib –with-mysql-dir=C:\mysql-connector-c-noinstall-6.0.2' |
4. Output will return in below manner:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Temporarily enhancing PATH to include DevKit… | |
Building native extensions with: '–with-mysql-include=C:\mysql-connector-c-noinstall-6.0.2\include –with-mysql-lib=C:\mysql-connector-c-noinstall-6.0.2\lib — | |
with-mysql-dir=C:\mysql-connector-c-noinstall-6.0.2' | |
This could take a while… | |
Successfully installed mysql2-0.3.13 | |
Parsing documentation for mysql2-0.3.13 | |
unable to convert "\x90" from ASCII-8BIT to UTF-8 for lib/mysql2/mysql2.so, skipping | |
Installing ri documentation for mysql2-0.3.13 | |
1 gem installed |
5. If you see this message, create a new Rails4 application, open your Gemfile and use:
gem 'mysql2', '0.3.13'
and run bundle install. Once bundle install runs successfully. You should try:
rake db:create and
rake db:migrate
to ensure that gem is installed correctly.
Hope this will help someone!
Happy Coding!! 🙂