How to get rid of STRICT SQL mode in MySQL

Put sql-mode="" in an option file. For example, on CentOS, there is /usr/my.cnf you need to modify.

One thing need to watch out is that you need to search both sql-mode and sql_mode, in case there is existing setting. Although in the MySQL document it only mentions sql-mode for option file.

And both

sql-mode=NO_ENGINE_SUBSTITUTION 

and

sql-mode='NO_ENGINE_SUBSTITUTION'

will work.