Solutions

How to turn off MySQL strict mode?

Vishal J Jun-30th, 2015 0:14 3 0
Please follow the under mentioned instructions to turn off the MySQL strict mode. Make the following changes in the "my.ini/my.cnf":

1. Look for the following line:

sql_mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

2. Change it to:

sql_mode="" (Blank)

3. Restart the MySQL service.

Vote

Was this article helpful?
3 out of 3 found this helpful