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
How can I purchase a maintenance renewal?
Viewed 10253 times since Mon, Aug 8, 2011
How to enable mbstring in PHP?
Viewed 339162 times since Wed, Feb 6, 2013
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
How to upgrade from PHPKB version 7.x to 8.0
Viewed 4018 times since Mon, Jan 23, 2017
MySQL server has gone away
Viewed 171 times since Thu, Aug 2, 2018