Skip to content

Instantly share code, notes, and snippets.

@snipe

snipe/mysql-strict

Created November 26, 2013 23:17
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 snipe/7668037 to your computer and use it in GitHub Desktop.
Save snipe/7668037 to your computer and use it in GitHub Desktop.
Download ZIP
Turn on mysql strict mode for Mac OSX mysql/MAMP
Raw
mysql-strict
As priv'd user,
SET @@global.sql_mode='STRICT_TRANS_TABLES';
SET @@global.sql_mode='STRICT_ALL_TABLES';
@snipe
Copy link
Author

snipe commented Aug 20, 2014

SET @@global.sql_mode="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