I need do it this, and work correctly:
- To disable strict SQL mode, SSH in to your server as root
- Create this file: /etc/mysql/conf.d/disable_strict_mode.cnf
-
Open the file and enter these two lines:
[mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
-
Restart MySQL with this command: sudo service mysql restart
https://stackoverflow.com/questions/11040207/disabling-mysql-strict-mode