How do I disable Strict Mode in MySQL?
Article ID: 163 | Rating: 2/5 from 1 votes | Last Updated: Tue, Mar 14, 2017 at 1:13 AM
Please follow the instructions that are given below in order to turn off the MySQL Strict Mode.
NOTE: Make the following changes in the my.ini (for Windows Operating System) or my.cnf (for Linux Operating System):
- Look for the following line:
sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
- Change it to:
- Restart the MySQL Service.
There are no attachments for this article.
There are no comments for this article. Be the first to post a comment.
SEO Friendly URLs Not Working
Viewed 8879 times since Fri, Mar 18, 2016
MySQL server has gone away
Viewed 171 times since Thu, Aug 2, 2018
How to use Import From HTML Module?
Viewed 15304 times since Fri, Nov 9, 2012