Customizing MySQL for WHMCS 7
As WHMCS 7 was not written to support modern MySQL syntax, you must make customizations to MySQL to install and use WHMCS 7 with MySQL 5.7.
SSH in to your server as root and create a new configuration file using nano or the editor of your choice:
sudo nano /etc/mysql/conf.d/disable_strict_mode.cnf
In the file, enter these two lines:
Finally, restart MySQL with this command:
sudo service mysql restart
Last updated: October 06, 2016