Unable to install MySQL2 gem on Windows 7

by

The specific version of mysql2 gem you’re trying to install (0.2.4) not only lacks binaries for Windows, but have issues on Windows.

Please install mysql2 gem without indicating the version:

gem install mysql2

Which will install latest version (0.2.6 at the time of my posting this) and also provides binaries for Windows which skip the compilation step.

If you still want to force the compilation (because your version of MySQL differs from the one used to generate the binary gem, you will need to install RubyInstaller’s DevKit from RubyInstaller website:

http://rubyinstaller.org/downloads

And follow the DevKit installation instructions from our wiki (that is linked from the download page)

You will need to provide the path to both headers and libraries during the gem installation process, and adjust the MySQL installation location from the following instructions:

subst X: "C:\Program Files (x86)\MySQL\MySQL Server 5.1" 
gem install mysql2 --platform=ruby -- --with-mysql-dir=X: --with-mysql-lib=X:\lib\opt 
subst X: /D

The above command uses subst to avoid issues with path with spaces, which you should avoid always.

Hope this helps.

More Related Contents:

  1. Mysql2::Error::ConnectionError: Access denied for user
  2. Error installing mysql2: Failed to build gem native extension
  3. bundle install fails with SSL certificate verification error
  4. ‘sudo gem install’ or ‘gem install’ and gem locations
  5. no such file to load — rubygems (LoadError)
  6. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  7. Nokogiri installation fails -libxml2 is missing
  8. How do I “activate” a different version of a particular gem?
  9. How to use bundler behind a proxy?
  10. How do I use RVM and create globally available gems?
  11. How can I specify a local gem in my Gemfile?
  12. Convert HTML to word file ?
  13. How do I display Ruby on Rails form validation error messages one at a time?
  14. How do I use gems with Ubuntu?
  15. nokogiri gem installation error
  16. Ruby: problem installing EventMachine under Windows 7
  17. “gem install rails” fails with DNS error
  18. String.force_encoding() in Ruby 1.8.7 (or Rails 2.x)
  19. unable to install pg gem
  20. Failed to build gem native extension — Rails install
  21. Why can’t I install the SQLite gem?
  22. macOS, Rails: “Failed to build gem native extension”
  23. sqlite3 gem fails to install
  24. How to fix “Your Ruby version is 2.3.0, but your Gemfile specified 2.2.5” while server starting
  25. Ruby 1.9.2 and Rails 3 cannot open rails console
  26. Ruby 1.9.2 how to install RMagick on Windows?
  27. Difference between attr_accessor and attr_accessible
  28. Rails model without database
  29. Run rake task in controller
  30. How to save a base64 string as an image using ruby

Leave a Comment