
How to disable MySQL strict mode on WHM cPanel
0
0
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.
Source: https://forums.cpanel.net/threads/trying-to-disable-mysql-strict-mode.549011/#post-2221011
Open a SSH session as root.
Edit the /usr/my.cnf file
nano /usr/my.cnf
Find the line:
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
and replace it with the following:
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
I hope you found this useful. Please follow us on Facebook and twitter or subscribe to us on Youtube.