Internal case CPANEL-5992 is open to address reports of user confusion regarding changes to the sql_mode MySQL configuration value when the /usr/my.cnf file is in-use. The following cPanel thread will be updated with the outcome of this case once it’s marked as resolved. In the meantime, you can manually modify the /usr/my.cnf to configure the value to your own preference.
Open a SSH session as root.
Edit the /usr/my.cnf file
Find the line:
and replace it with the following:
I hope you found this useful. Please follow us on Facebook and twitter or subscribe to us on Youtube.