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 11297 times since Fri, Mar 18, 2016
SEO Friendly URLs not working in PHPKB
Viewed 6710 times since Tue, Apr 11, 2017
How to use Import From HTML Module?
Viewed 16841 times since Fri, Nov 9, 2012