mysql2: cannot load such file -- mysql2/2.4/mysql2 (LoadError)`

I am new on Ruby on Rails. My Ruby version is ruby2.4.1p111 (2017-03-22 revision 58053) [x64-mingw32].

I have created a new project using rails new sample_cms -d mysql command.

The command rails server is throwing following error.

C:/Ruby24-x64/lib/ruby/gems/2.4.0/gems/mysql2-0.4.6-x64-mingw32/lib/mysql2/mysql2.rb:2:inrequire’: cannot load such file – mysql2/2.4/mysql2 (LoadError)` I have installed mysql and mysql Connector C. I have installed the mysql2 gem like that.

gem install mysql2 —platform=ruby — ‘—with-mysql-dir=“C:\Program Files\MySQL\MySQL Connector C 6.1”’ I have uninstall and install the mysql2 gem but still facing the issue. Here is the directory which may have issue.

27505154-7b8f3f4e-58b2-11e7-8c8a-66980553443c

Here is the gem file entry for mysql2

Bundle edge Rails instead: gem ‘rails’, github: ‘rails/rails’

gem ‘rails’, ‘~> 5.1.1’

Use mysql as the database for Active Record

gem ‘mysql2’, ‘>= 0.3.18’, ‘< 0.5’

Use Puma as the app server

gem ‘puma’, ‘~> 3.7’ Any Help?

About this issue

Original URL
State: closed
Created 7 years ago
Comments: 23

Commits related to this issue

Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the mysql2 ge... — committed to larskanis/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows (#875) Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the ... — committed to brianmario/mysql2 by larskanis 7 years ago
Fix compat with RubyInstaller-2.4 on Windows (#875) Since RubyInstaller-2.4+ is bundled with MSYS2 and the libmariadbclient can be installed per gemspec library dependency, it is easy to build the my... — committed to junaruga/mysql2 by junaruga 7 years ago

Most upvoted comments

Worked for me on Ruby 2.4.3 on Windows 10 as shown below. Be sure to get the Mysql server (or) MySQL C connector where it includes lib and include folders.

C:\Users\nash\excg>gem install mysql2 --platform=ruby -- '--with-mysql-lib="I:\mysql-5.7.19-winx64\lib" --with-mysql-include="I:\mysql-5.7.19-winx64\include"'
Temporarily enhancing PATH for MSYS/MINGW...
Building native extensions with: '--with-mysql-lib="I:\mysql-5.7.19-winx64\lib" --with-mysql-include="I:\mysql-5.7.19-winx64\include"'
This could take a while...
Successfully installed mysql2-0.4.9
Parsing documentation for mysql2-0.4.9
Installing ri documentation for mysql2-0.4.9
Done installing documentation for mysql2 after 1 seconds
1 gem installed

+10

nengine on Oct 10, 2017

Same here with Ruby 2.4.1 on Windows 10. Thanks.

nengine on Sep 30, 2017

This is why Ruby and Rails stayed niche. Python and other language ecosystems weren’t broken on Windows.

AlchemistCamp on Apr 3, 2018

+1 Experiencing the same problem. Any updates?

fatalerrorx on Sep 9, 2017

Is there any ETA as to when this may be resolved, or 0.5.0 may be released?

soundasleep on Aug 19, 2017