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

 

Leave a Reply

Your email address will not be published. Required fields are marked *