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

Article ID: 163
Created: Tue, Mar 14, 2017
Last Updated: Tue, Mar 14, 2017
Author: Palwinder Singh

Online URL: https://www.knowledgebase-script.com/kb/article/how-do-i-disable-strict-mode-in-mysql-163.html