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. 

Get Windows VPS Hosting
Was this answer helpful? 0 Users Found This Useful (0 Votes)

Most Popular Articles

Error 1503: Error while restarting MySQL service on Windows server

You may need to restart MySQL services from Services on the Windows server. While restarting...
How to Enable Relation View in phpMyAdmin?

The option Relation View is probably one of the best features available in phpMyadmin. Sometimes...
How to resolve “mcrypt extension is missing. Please check your PHP configuration” error in phpMyAdmin?

This article will guide you on resolving the “mcrypt extension is missing. Please check your PHP...
How to enable Remote Access for MariaDB in virtualmin?

For web hosts looking to make better use of their resources, moving the database server to a...
How do I connect to MySQL server from phpMyAdmin?

This article will guide you on how to connect to the MySQL server from phpMyAdmin. 1. You can...