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
I receive an Internal Server Error or HTTP 500 message
Viewed 19491 times since Wed, Dec 5, 2012
How to enable mbstring in PHP?
Viewed 365698 times since Wed, Feb 6, 2013
Can I use the PHPKB software without active support subscription?
Viewed 9974 times since Mon, Aug 8, 2011
MySQL server has gone away
Viewed 1812 times since Thu, Aug 2, 2018
How do I migrate/move my installation of PHPKB to another server?
Viewed 13423 times since Sat, May 12, 2012
Support Subscription Renewal - Commonly Asked Questions
Viewed 7580 times since Wed, Jun 25, 2014
How to motivate people to contribute to a Knowledge Sharing System?
Viewed 72421 times since Mon, Nov 7, 2011