Admin-Ahead Community

General Category => General Discussion => Topic started by: dustin on August 16, 2014, 07:19:54 am

Title: Changing mysql strict mode
Post by: dustin on August 16, 2014, 07:19:54 am

If MysQL mode is in strict and some commands aren't going through. This mode enforces very explicit restrictions on the data and format of data that goes into the table columns

To turn off strict mode in MySQL, edit the my.ini or my.cnf file

change the sql-mode line to:
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

===