Disabling MySQL Strict Mode

It is important that MySQL Strict Mode is disabled for the proper operation of WHMCS. In this example we will detail how to properly edit the MySQL Configuration on a cPanel server to ensure we are using the proper SQL Mode.

Note: In order to make the following changes, you will need full root permissions for the server you are on. If you do not have full root permissions, you will need to contact your web host or sysadmin to request this be done.

Using your favorite SSH Client or via the built in Terminal feature of WHM. In this case we will be using the Terminal Feature found within WHM v72+. If you are using an older version of WHM/cPanel, the steps are the same via your SSH client.

To get started, simply navigate to the Terminal option found under the Server Configuration heading in WHM.

Once in the terminal session, open the MySQL configuration file up with your favorite text editor (nano, vi, etc.). For cPanel servers, the location of the MySQL Configuration file is /etc/my.cnf and we will edit it by doing the following:

Edit the sql_mode value within this file and remove any value it has. The result should be as follows:

Restart the MySQL service. Since we are already logged into WHM, simply choose to restart the MySQL service from the left-hand column: