Home Cpanel/WHM How to disable MySQL strict mode on WHM cPanel
How to disable MySQL strict mode on WHM cPanel

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.

Addicted2Tech We love technology and enjoy sharing helpful content for others to enjoy. we believe in community and open source. We are huge Linux advocates. We stand for privacy and security and above all else transparency and fairness. If you like what we do please follow us on social media.