Support Knowledge Base

How do I disable Strict Mode in MySQL?

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):

  1. Look for the following line:
    sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  2. Change it to:
    sql-mode="" (Blank)
  3. Restart the MySQL Service.

That's all!

Custom Fields
  • Applicable To: Standard Edition, Standard (Multi-Language) Edition, Enterprise Edition (MySQL), Enterprise Multi-Language Edition (MySQL), Enterprise Edition (SQL Server), Enterprise Multi-Language Edition (SQL Server)
2 (1)
Article Rating (1 Votes)
Rate this article
Attached Files
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Security Code Security Code
Related Articles RSS Feed
Enterprise Wiki Software - Criteria for selection and evaluation of wiki software
Viewed 4864 times since Fri, Aug 26, 2016
Can I use the PHPKB software without active support subscription?
Viewed 9000 times since Mon, Aug 8, 2011
How to enable text selection and copying on article page?
Viewed 8913 times since Thu, Jan 22, 2015
Support Subscription Renewal - Commonly Asked Questions
Viewed 6627 times since Wed, Jun 25, 2014
SEO Friendly URLs Not Working
Viewed 8879 times since Fri, Mar 18, 2016
Unable to upload large files or no data received on "Save Article" page
Viewed 2900 times since Thu, May 26, 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