How to turn on/off Mysql strict mode in the Windows server?

By default in the windows server, the strict mode will be enabled on MySQL. Please refer to the following steps to disable strict mode.

  1. Login to your windows server.

  2. You will need to find my.ini to disable strict mode in MySQL.  Go to C:\ProgramData\MySQL\MySQL Server 5.7



  3. In Windows OS, the ProgramData folder is hidden. To show hidden folder, you can tick on "View" from Menu Bar -> Select hidden items.

  4. You can find the my.ini file from "C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

  5. Open my.ini file with Notepad/Notepad++ and find the following line.

    sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"


  6. You need to set sql-mode to Blank and save the file.

    sql-mode = ""


  7. Restart the MySql service from service. Please refer to Restart > MySQL in Windows or Linux system. 

Related Articles

How to generate MySQL (backup) dump from the command line in Windows VPS?

This article will assist you how to generate MySQL (backup) dump from the Command line in the...

How to Clone MySQL database using PhpMyAdmin?

Database clone is a process to create a separate copy of the database. You can also use it as...

How to Stop and Start MySQL Service in Windows and Linux VPS?

This article will assist you to stop and start MySQL service from Windows VPS and Linux VPS....

How to change phpMyAdmin password?

Following tutorial will guide you to reset the phpMyAdmin password. We assume that you have...

Fix - Collection Max error, Cannot Connect to Server

Problem Statement Recently one of our customers was unable to connect to Collection Max and...

  • 0 Users Found This Useful

Was this answer helpful?