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 … Read more
Just do: gem ‘mysql2’, ‘~> 0.3.18’ this gem works with rails version 4.x.x if install gem ‘mysql2’, ‘~> 0.4.0’ it produces gem load error and causes compatibility issues
Had the absolutely same issue on Windows 7 x64 with Ruby 2.0.0 and DevKit 4.7. The following steps helped me. gem uninstall mysql2 Download last MySQL connector from http://cdn.mysql.com/Downloads/Connector-C/mysql-connector-c-noinstall-6.0.2-win32.zip Extract it to C:\connector-6.0.2 gem install mysql2 –platform=ruby — ‘–with-mysql-lib=”C:\connector-6.0.2\lib” –with-mysql-include=”C:\connector-6.0.2\include” –with-mysql-dir=”C:\connector-6.0.2″‘ Or even shorter: gem install mysql2 –platform=ruby — –with-opt-dir=”C:\connector-6.0.2″
Ubuntu: sudo apt-get install libmysqlclient-dev #(mysql development headers) sudo gem install mysql2 — –with-mysql-dir=/etc/mysql/ That’s it! Result: Building native extensions. This could take a while… Successfully installed mysql2-0.2.6 1 gem installed Installing ri documentation for mysql2-0.2.6… Enclosing class/module ‘mMysql2’ for class Result not known Enclosing class/module ‘mMysql2’ for class Client not known Installing RDoc documentation … Read more
Step 1: confirm you have both openssl and MySQL installed via brew brew install mysql brew install openssl or if you have previous version of openssl try brew reinstall openssl@3 Step 2: Run this on your Rails app to make sure you can get through bundler: gem install mysql2 -v ‘0.5.3’ — –with-opt-dir=$(brew –prefix openssl) … Read more
You can pass a string that is the join-sql too. eg joins(“LEFT JOIN StudentEnrollment se ON c.id = se.course_id”) Though I’d use rails-standard table naming for clarity: joins(“LEFT JOIN student_enrollments ON courses.id = student_enrollments.course_id”)
The problem comes from the mysql2 gem missing the dynamic library from MySQL. A cleaner solution than install_name_tool … would need to update your DYLD_LIBRARY_PATH to add MySQL libs to it. To do so, update your ~/.bash_profile to add the MySQL library folder : export DYLD_LIBRARY_PATH=”/usr/local/mysql/lib:$DYLD_LIBRARY_PATH” Note: You might want to update the MySQL location … Read more
EDIT 30/09/2014 When this answer was posted the 64 bit rails installer wasn’t the recommended version – it now seems people are starting to use it more. It should be noted when you download the MySQL Connector you need to download either 64 or 32bit to correspond to the version of rails you installed. Amazingly … Read more
Uninstalling and reinstalling the gem will often solve this issue with no need to download and move files around by hand. From your rails app directory: > gem uninstall mysql2 You have requested to uninstall the gem: mysql2-0.3.11 database_cleaner-0.9.1 depends on [mysql2 (>= 0)] If you remove this gems, one or more dependencies will not … Read more
On Ubuntu/Debian and other distributions using aptitude: sudo apt-get install libmysql-ruby libmysqlclient-dev Package libmysql-ruby has been phased out and replaced by ruby-mysql. This is where I found the solution. If the above command doesn’t work because libmysql-ruby cannot be found, the following should be sufficient: sudo apt-get install libmysqlclient-dev On Red Hat/CentOS and other distributions … Read more