disable sql mode in mysql

Subject:

This problem scuppered me for a while as well. None of the answers so far addressed the original problem but I believe mine does so I'll post it in case it helps anyone else.

I have MySQL (from mysql.com) Community Edition 5.7.10 installed on OS X 10.10.3

In the end I created a /etc/mysql/my.cnf with the following contents:-

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION

After restarting the server a SHOW VARIABLES LIKE 'sql_mode'; gave me:-

+---------------+------------------------+ | Variable_name | Value | +---------------+------------------------+ | sql_mode | NO_ENGINE_SUBSTITUTION | +---------------+------------------------+ 1 row in set (0.00 sec)

Finally, no strict mode!

2016-11-30 10:12:13gstlouis

Centos7 with virtualmin
mysql 5.7 community
/etc/my.cnf

just below [mysqld]
I put sql_mode=NO_ENGINE_SUBSTITUTION
systemctl restart mysqld
I can not add 0000-00-00 00:00:00 to modified field along with create being current time stamp

gstlouis
vote
2017-07-11 19:09:57