Nov 24 2020 
Support Center » Knowledgebase » Disable MySQL Strict Mode
 Disable MySQL Strict Mode
Solution 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.




Article Details
Article ID: 100
Created On: Aug 11 2020 09:49 AM

 Back
 Login  
Email:
Password:
 
 Search
 Article Options
Back to awbs.com | Home | Knowledgebase | Troubleshooter | Support Forum
© 2010 Total Online Solutions, Inc.