Install Ruby Mysql Gem Windows

Install Ruby using rubyinstaller: install to the C drive to a folder without spaces, eg c:/Ruby193 Install RubyGems: on command line do: 'gem install rails' Install DevKit from: following these instructions: Install the latest version of MySQL Community Server: Install the no-install MySQL connector following these instructions from Update: mysql gem version `2.9.0` already fix the issues shown here. Install it normally and follow the on-screen instructions.

In order to use my brand new MySQL installation, now I need to install the MySQL bindings for it. But, there is a small detail: Ruby is 32bits and my MySQL is 64bits, this means I can’t use MySQL provided libraries from Ruby. You told me to install the 64bits version! Don’t despair! MySQL Connector to the rescue! Cambridge Soundworks Fps 2000 Digital Drivers. That is right, MySQL has something called Connector, the purpose of that library is to avoid a complete MySQL installation when you just need to connect to a remote one.

Just in case here's the general outline of what you'd need to get up and running with MySQL instead of SQLite in rails: Install MySQL. Add the mysql2 gem to your Gemfile (currently at version 0.3.16 but check rubygems): Run bundle install from the command line. Setup your database credentials in config/database.yml. Feb 25, 2016. Assuming you have MySQL installed on your Windows box residing in c: Program Files MySQL MySQL Server 5.5. 1) Download [libmysql.dll][1]. Copy the above libmysql.dll to. F: Dev ruby-1.9.3 bin AND F: Dev ruby-1.9.3 lib, or wherever your lib and bin are. 2) Open cmd and run: gem. Jul 14, 2013 - 23 min - Uploaded by Jonathan MacDonaldLatest instructions (as of June 2014): ih4txNf7w_U&list.

It comes in different flavors, we are interested in C language support, since that is the language Ruby uses for it’s extensions. We are going to download a 32bits connector and use it! So, at my web browser again, decided to visit the MySQL Connector/C download page: Since I’m not interested in installing this Connector and pollute my clean 64bits installation, I’m going to download the non-installer version. I scrolled down the listing until I saw the noinstall 32bits version: mysql-connector-c-noinstall-6.0.2-win32.zip Decided to extract it to the root of my disk, so I ended with a folder named mysql-connector-c-noinstall-6.0.2-win32 in there. Remember: extract into a folder without spaces (something like c: mysqlconnector ).

The same goes for your Ruby installation and the DevKit installation. Hit the Windows button and type Ruby, open 'Command Prompt with Ruby and Rails' type 'where libmysql.dll' it should show up ONLY in your RailsInstaller Ruby1.9.3 bin directory if it's anywhere else, find the file on your computer and rename it temporarily.

Then run these two commands with the directory you extracted the mysql connector to: gem install mysql --platform=ruby -- --with-mysql-lib=C:/mysqlconnector/lib --with-mysql-include=C:/mysqlconnector/include gem install mysql2 --platform=ruby -- --with-mysql-lib=C:/mysqlconnector/lib --with-mysql-include=C:/mysqlconnector/include If it works, type 'require mysql'. Simcity 4 Deluxe Edition Free Download Full Version. You'll likely get an error that libmysql.dll is missing. Add the file from the mysqlconnector/lib folder to your Ruby bin folder and windows system32 folder. Type require mysql again and it should work Resources: https://groups.google.com/forum/?fromgroups=#!searchin/rubyinstaller/mysql$20windows/rubyinstaller/DTSQdQjX8bY/MgiNW7CMO4oJ.