Disable MySQL Strict Mode

Article Details
URL: https://www.awbs.com/hd/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=100
Article ID: 100
Created On: Aug 11 2020 09:49 AM

Answer 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.