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

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