Skip to content

Instantly share code, notes, and snippets.

@ryanburnette

ryanburnette/mysql.cnf

Created July 13, 2020 20:32
Show Gist options
  • Save ryanburnette/9d861f9117d0a22e0847828168d882fc to your computer and use it in GitHub Desktop.
Save ryanburnette/9d861f9117d0a22e0847828168d882fc to your computer and use it in GitHub Desktop.
Download ZIP
mysql no zero date issue
Raw
mysql.cnf
# /etc/mysql/mysql.conf.d/mysql.cnf
[mysqld]
sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
@ryanburnette
Copy link
Author

Had to add this to the mysql configuration under [mysqld]. Required reading all the comments to work it out.

https://stackoverflow.com/a/41136490/2535178

@ryanburnette
Copy link
Author

This has only ever occurred for me when restoring a MySQL database manually from VaultPress on WordPress.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment