Skip to content

Instantly share code, notes, and snippets.

@patricksimpson

patricksimpson/fix-mysql-5-7

Created February 23, 2017 16:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save patricksimpson/ebb427cae88a7ffc8cd28923f8e1ff84 to your computer and use it in GitHub Desktop.
Save patricksimpson/ebb427cae88a7ffc8cd28923f8e1ff84 to your computer and use it in GitHub Desktop.
Download ZIP
fix mysql 5.7 on macos serria
Raw
fix-mysql-5-7
If you have installed mysql 5.7 using homebrew, on macos serria
Edit your file ~/.my.cnf ( If it does not exist, create it. )
Add the following lines:
[mysqld]
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Save and exit the file.
In your terminal type: brew doctor
After that is complete type: brew services restart mysql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment