Skip to content

How to turn off MySQL strict mode?

Follow the below mentioned instructions to turn off or to disable the MySQL strict mode. This can be fixed in one of two ways

Method 1.
Make the following changes in the “my.ini/my.cnf”:

1. Look for the following line , this line will set MySQL strict mode
sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

2. To disable MySQL strict mode, you can change the above line as follow:
sql_mode="TRADITIONAL,NO_AUTO_CREATE_USER,,NO_ENGINE_SUBSTITUTION"

3. Restart the MySQL service.

Method 2 :
You may be able to run an SQL query within your database management tool such as phpMyAdmin which can normally be found from your web hosting control panel:

SET @@global.sql_mode= '';

0 0 votes
Article Rating
Subscribe
Notify of
guest

1 Comment
Most Voted
Newest Oldest
Inline Feedbacks
View all comments