Disable SQL strict mode in Mysql 5.7

By:
On:
In: Database

Disable SQL strict mode in Mysql 5.7

Add this to /etc/mysql/mysqld.conf/mysqld.conf

[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION