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
Why should I renew my software maintenance?
Viewed 11131 times since Mon, Aug 8, 2011
SEO Friendly URLs Not Working
Viewed 11297 times since Fri, Mar 18, 2016
SEO Friendly URLs not working in PHPKB
Viewed 6710 times since Tue, Apr 11, 2017
How to upgrade from PHPKB version 7.x to 8.0
Viewed 6286 times since Mon, Jan 23, 2017
How to use Import From HTML Module?
Viewed 16841 times since Fri, Nov 9, 2012
Problem with Truncated Article Content for SQL Server Edition
Viewed 5978 times since Thu, Feb 9, 2012
Can I use the PHPKB software without active support subscription?
Viewed 9811 times since Mon, Aug 8, 2011