Skip to content

Instantly share code, notes, and snippets.

@anaxamaxan

anaxamaxan/loosening sql mode in MySQL 5.7

Last active January 25, 2016 03:44
Show Gist options
  • Save anaxamaxan/fe04b1e117033a381e93 to your computer and use it in GitHub Desktop.
Save anaxamaxan/fe04b1e117033a381e93 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
loosening sql mode in MySQL 5.7
# in Homestead and typical Ubuntu, put this in /etc/mysql/my.cnf
# right after explicit_defaults_for_timestamp
sql-mode = "ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
# Also, if you execute .sql file from an older MySQL version, you might get errors befause the ROW_FORMAT=FIXED is no
# longer a valid option. Search all ROW_FORMAT=FIXED replace with ROW_FORMAT=DYNAMIC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment