MySQL Strict Mode

This guide is based on:

• MySQL 5.7.28
• MySQL Workbench 8.0 CE
• WAMP 3.2

To turn OFF strict mode:

1. Navigate to the WAMP install folder, and then the MySQL install folder inside of it
   
2. Open the cofig file my.ini
3. Look for sql-mode (use Ctrl+F to search)
4. Comment out the line with sql-mode (line 68, in my case), and add a line with empty sql-mode
   • Comments are denoted with semicolons (;)
     

Notes

• You can reverse this to turn strict mode back on
• If WAMP is running, you will need to restart MySQL service for changes to take effect