Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)

by

The problem is that the mysql2 gem is not installing with its native dependencies. In previous versions of Ruby, this would have triggered the unable to build native gem extension error:

enter image description here

Something has changed in Ruby 2.2 so that you can install the gem without it building the native extension. This does not mean the problem is resolved however – and so you have to ensure you install the gem with the appropriate dependencies.

Tutorial:

  1. Download C-Connector from MYSQL (note your version of Ruby — if you’re using 64 bit, download the 64 bit version)

  2. Unzip / Install the MYSQL C-Connector folder onto your HDD (don’t have any spaces in the path)

  3. Run the following command: gem install mysql2 --platform=ruby -- '--with-mysql-dir="C:/your-mysql-connector-path"'

  4. This should install the gem with the files it needs

  5. Then you can copy libmysql.dll from C:/your-mysql-connector-path -> c:/your-ruby-install/bin`

The difference between this install and the previous one will be that this should mention that the native gem extensions are being installed (This could take a while), which suggests that Ruby is looking at the library.

This time, if it installs correctly, it should work for you.

—

If you’re still seeing an error, you’ll have to uninstall any existing versions of the mysql2 gem on your system:

How to install mysql2.

If you’re getting an error, you just need to type gem uninstall mysql2, select all and then repeat the steps above.

More Related Contents:

  1. How do you write a case insensitive query for both MySQL and Postgres?
  2. Error installing mysql2: Failed to build gem native extension
  3. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  4. Deploying RoR app to Heroku with SQLite 3 fails
  5. SQL table with “list” entry vs SQL table with a row for each entry
  6. Quick easy way to migrate SQLite3 to MySQL? [closed]
  7. PostgreSQL GROUP BY different from MySQL?
  8. Convert MySQL to SQlite [closed]
  9. mysql2 gem compiled for wrong mysql client library
  10. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  11. Rails, MySQL and Snow Leopard
  12. Change from SQLite to PostgreSQL in a fresh Rails project
  13. Why do results from a SQL query not come back in the order I expect?
  14. MySQL Install: ERROR: Failed to build gem native extension
  15. Heroku deployment failed because of sqlite3 gem error
  16. Export a MySQL Database to SQLite Database
  17. HEROKU – cannot run git push heroku master [duplicate]
  18. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  19. how to use DISTINCT ON with mysql using ActiveRecord
  20. How to delete duplicate records in mysql database?
  21. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  22. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  23. Pushing Rails with SQLite3 to Heroku fails [duplicate]
  24. How to restrict a column value in SQLite / MySQL
  25. Correct MySQL configuration for Ruby on Rails Database.yml file
  26. What the difference between mysql and mysql2 gem
  27. What are the max number of allowable parameters per database provider type?
  28. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  29. Rails select random record
  30. Errors of pushing rails app to Heroku error occurred while installing sqlite3, and Bundler cannot continue [duplicate]

Leave a Comment