How to disable MySQL strict mode?
Disabling MySQL strict mode is an important operation in WHMCS. In this Blog we will learn how to properly edit MySQL Configuration on a cPanel server to ensure that a consumer using the proper SQL Mode.
Important Note:To make the following changes, the server you are on will need full root permission If you do not have full root permission, you will need to contact your web host or system administrator to request it.
Using your favorite SSH client or through WHM's built-in terminal function. In this case, we will use the terminal function found in WHM v72+. If you are using an older version of WHM/cPanel, the steps are the same through your SSH client.
To get started, go to the Terminal option found under the Server Settings heading in WHM.
Once in the terminal session, open the MySQL configuration file 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.