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 to 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:
[root@srv012 ~]# nano -w /etc/my.cnf
Edit the sql_mode value within this file and remove any value it has. The result should be as follows:
[mysqld]
log-error=/var/lib/mysql/srv012.hostname.tld.err
performance-schema=0
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
sql_mode=
Restart the MySQL service. Since we are already logged into WHM, simply choose to restart the MySQL service from the left-hand column.
