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:
# nano /etc/my.cnf
Edit the sql_mode value within this file and remove any value it has. The result should be as follows:
[mysqld]
sql_mode = ''
If the sql_mode item is missing, add it.
Restart the MySQL service. If you are already logged into WHM, simply choose to restart the MySQL service from the left-hand column.
