How to turn off MySQL strict mode in Rails

mysql ruby-on-rails ruby-on-rails-4 database-connection strict

You can set strict mode in your database.yml using strict: false as follows:

production:  host: ...  username: ...  strict: false

mysql ruby-on-rails ruby-on-rails-4 database-connection strict

The mysql2 gem exposes an option to execute an initial command on connect and reconnect. You can set the init_command from inside database.yml:

production:  host: ...  username: ...  init_command: "SET @@SESSION.sql_mode = ''"

mysql ruby-on-rails ruby-on-rails-4 database-connection strict

You can add this to your database.yml

variables:   sql_mode: 'traditional'

variables:   strict_mode: false

See:

CodeHunter