How to disable Strict mode in Mysql

Apps written for older versions of MySQL will not be compatible with strict SQL mode in MySQL 5.7. So we need to disable Strict mode for the proper functioning of those applications.

This article explains the steps to disable Strict mode in Mysql.

Step1: Open the mysql configuration '/etc/my.cnf'

#vi /etc/my.cnf

Step2: Replace the line as below.

sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

to

sql-mode=""

Step3: Restart mysql service

#service mysql restart

 

Leave a Reply

Your email address will not be published. Required fields are marked *