Skip to content

Instantly share code, notes, and snippets.

@pgrimaud
Last active August 24, 2017 12:46
Show Gist options
  • Save pgrimaud/5ca343791e31e297c851e8234db3acc1 to your computer and use it in GitHub Desktop.
Save pgrimaud/5ca343791e31e297c851e8234db3acc1 to your computer and use it in GitHub Desktop.
FIxed : this is incompatible with sql_mode=only_full_group_by

Fix for vagrant:

mysql:
    install: '1'
    settings:
        version: '5.6'
        root_password: root
        override_options:
          mysqld:
            sql_mode: 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
    users: {  }
    databases: {  }
    grants: {  }
SET global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment