Sql_mode getting ignored

ViAdCk

Verified User
Joined
Feb 14, 2005
Messages
287
Hello,

We just installed a fresh server with mysql 5.6.51 and it's not accepting sql_mode when we configure it in the my.cnf file.

We want to remove STRICT_TRANS_TABLES and just configure my.cnf with the following option sql-mode="NO_ENGINE_SUBSTITUTION"

But this configuration is not being reflected after a mysql restart. Only if we edit the sql mode through phpmyadmin it works but these changes are lost after a mysql restart.

Any idea what could be going on?

Thanks!
 
Top