How do I disable Strict Mode in MySQL?

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.

Reference:

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

Article ID: 37
Created On: Mon, Sep 28, 2020 at 1:49 AM
Last Updated On: Mon, Sep 28, 2020 at 1:49 AM
Authored by: Saeed Nobakht [[email protected]]

Online URL: https://www.navel.ir/article/how-do-i-disable-strict-mode-in-mysql-37.html