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!
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!