How do I disable Strict Mode in MySQL?
Article ID: 163 | Rating: 1.5/5 from 2 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 11721 times since Fri, Mar 18, 2016