MySQL Linux 5.6 Remove Strict_trans_tables

Many articles on the web say that if you encounter

MySQL 1364 Error Tip: #1364-field "" doesn ' t have a default value

Description you have configured "Strict_trans_tables"

However, you may find that modifying the MY.CNF (under Windows for My.ini) restarts MySQL with no end-of-question:

Use SELECT @ @GLOBAL. Sql_mode query or with strict_trans_tables;

Turned out to be no solution thoroughly:

Http://dev.mysql.com/doc/refman/5.6/en/option-files.html

The inside mentions:

On Unix, Linux and OS X, MySQL programs read startup options from the following files, in the specified order (top files A Re read first, later files take precedence).

The possible reason is that you modify that MY.CNF is not the highest priority (that is my case),/ETC/MY.CNF is a,/USR/LOCAL/MYSQL/MY.CNF has a higher priority, so rebooting does not remove the strict mode.

This article is from the "Hardware_accelerator" blog, make sure to keep this source http://panyf.blog.51cto.com/2185776/1686799

MySQL Linux 5.6 Remove Strict_trans_tables