Sign up to Our

NEWSLETTER


 
To answer your question faster, you can search our knowledgebase articles before submitting a ticket.
Knowledgebase
How to turn off MySQL strict mode
Posted by Edward T. on 03 September 2016 05:21 AM

When the MySQL strict mode is one, you may experience some unexpected issues with WPL (and some other well known web applications)

Please follow mentioned instruction to turn it off.

First, you should have SSH access to your Server, and login into it.
If you don't have any experience with Linux shell, We highly recommend to ask someone with enough knowledge to make it for you.

Please make following changes to the MySQL configuration file, it could be find at the "/etc/my.cnf" (or just my.ini in windows based servers)

1. Look for the following line:

sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

2. Change it to:

sql-mode = ""

(Blank, or just remove the 'STRICT_TRANS_TABLES,' part)

3. Save the file and Restart the MySQL service:

# /etc/init.d/mysqld restart

or

# service mysql restart

Well done!


Comments (0)