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)
1.5 (2)
Article Rating (2 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
SEO Friendly URLs Not Working
Viewed 11721 times since Fri, Mar 18, 2016
Article Links - Adding a link to an article in the knowledge base
Viewed 27681 times since Wed, Jan 30, 2013
Installation of the Attachment Indexing plugins
Viewed 87470 times since Tue, Feb 12, 2013
How to upgrade from PHPKB version 7.x to 8.0
Viewed 6690 times since Mon, Jan 23, 2017
Why should I renew my software maintenance?
Viewed 11383 times since Mon, Aug 8, 2011
How to motivate people to contribute to a Knowledge Sharing System?
Viewed 72418 times since Mon, Nov 7, 2011