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
From https://github.com/brianmario/mysql2/issues/8 just copied this in the console sudo apt-get install mysql-client libmysqlclient-dev and worked!!
This is just 2 different APIs written by regular people. Difference is in syntax of commands and maybe in performance, just install both, make your own tests for your goals and choose one you think is more suitable for you. Here is a comparison by NPMCompare:
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
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
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”)
For anybody still experiencing the issue: When you install openssl via brew, you should get the following message: Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries Generally there are no consequences of this for you. If you build your own software and it requires this formula, you’ll need … Read more