If you encounter this error again after upgrading to 12.04 (or for people arriving here after googling the title of this page after upgrading to 12.04), the following worked for me: gem uninstall mysql2 gem install mysql2 This will recompile the gem using libmysqlclient18, and worked for me.
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
I tried all the solutions posted here, but was not lucky. I reinstalled mysql with homebrew a couple of times and still no luck. Then I came across a blog post with a solution. I edited the mysql_config file in /usr/local/Cellar/mysql/5.6.12/bin and removed the W-compiler options -Wno-null-conversion and -Wno-unused-private-field for cflags and cxxflags. This solved … Read more
I actually had the wrong adaptor set on my database.yml So the fix is development: adapter: mysql2 database: development_database username: root password: Instead of adapter: mysql Doh!
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
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
I had the same problem, I managed to fix it. I did a lot of things, and I don’t know for sure what it was, but going to MySQL 5.6.10 seems to have worked. Uninstall MySQL 5.6.12: brew unlink mysql brew uninstall mysql Go to the homebrew directory: cd /usr/local Go to version 5.6.10 (you … Read more
The problem is on your file config/database.yml You should have a line that specify that the adapter is mysql2 (and not mysql) adapter: mysql2 Instead of adapter: mysql
I had a same problem before, and I solved according to here https://github.com/rails/rails/pull/13247#issuecomment-32425844 With Rails 2.3.5, MySQL version 5.7.9 and mysql gem you need to have this bit as an initializer in config/initializers/abstract_mysql_adapter.rb: class ActiveRecord::ConnectionAdapters::MysqlAdapter NATIVE_DATABASE_TYPES[:primary_key] = “int(11) auto_increment PRIMARY KEY” end For mysql2, it should be config/initializers/abstract_mysql2_adapter.rb: class ActiveRecord::ConnectionAdapters::Mysql2Adapter NATIVE_DATABASE_TYPES[:primary_key] = “int(11) auto_increment PRIMARY … Read more
None of the answers here helped me, but finally I got MySQL 5.6 to work. THREE options to fix MySQL 5.6: (confirmed) Edit /etc/my.cnf (create if not exists) and add: [mysqld] innodb_file_per_table = OFF and restart MySQL. Then for this to work you’ll need to dump your databases into SQL file (mysqldump), then drop and … Read more