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
What is software maintenance?
Viewed 10857 times since Mon, Aug 8, 2011
Article Links - Adding a link to an article in the knowledge base
Viewed 27128 times since Wed, Jan 30, 2013
How can I purchase a maintenance renewal?
Viewed 10977 times since Mon, Aug 8, 2011
How to use Import From HTML Module?
Viewed 16811 times since Fri, Nov 9, 2012
How to install wkhtmltopdf and configure in PHPKB
Viewed 11908 times since Fri, Dec 11, 2015
MySQL server has gone away
Viewed 1593 times since Thu, Aug 2, 2018
How do I migrate/move my installation of PHPKB to another server?
Viewed 13111 times since Sat, May 12, 2012
Can I transfer my license to another domain?
Viewed 8910 times since Mon, Aug 29, 2011