If your app was written for older versions of MySQL and is not compatible with strict SQL mode in MySQL 5.7, you can disable strict SQL mode. For example, apps such as WHMCS 6 and Craft 2 do not support strict SQL mode.If you're using WHMCS 7, see our article on customizing MySQL for WHMCS 7.To disable strict SQL mode, SSH in to your server as root and create this file:/etc/mysql/conf.d/disable_strict_mode.cnfOpen 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_SUBSTITUTIONRestart MySQL with this command:sudo service mysql restartThis change disables two SQL mode settings, STRICT_TRANS_TABLES and ONLY_FULL_GROUP_BY, that were added in MySQL 5.7…