How to Disable MySQL Strict Mode
To Disable MySQL Strict Mode, edit
1 |
vi /etc/my.cnf |
Add under [mysqld] section
1 |
sql_mode = "" |
Verify MySQL Strict Mode
To check if MySQL is running in strict mode, run
1 |
SELECT @@sql_mode; |
You get empty result if MySQL is not running under strict mode.
Here is a MySQL server running under strict mode
1 2 3 4 5 6 7 8 9 |
mysql> SELECT @@sql_mode; +-------------------------------------------------------------------------------------------------------------------------------------------+ | @@sql_mode | +-------------------------------------------------------------------------------------------------------------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +-------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> |
After disabling MySQL strict mode
1 2 3 4 5 6 7 8 9 |
mysql> SELECT @@sql_mode; +------------+ | @@sql_mode | +------------+ | | +------------+ 1 row in set (0.01 sec) mysql> |