• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.

Recommended Providers

Fully Managed WordPress Hosting
Fully Managed WordPress Hosting

WordPress Theme

WordPress Hosting Divi WordPress Theme

Forum Membership

Forum Membership

Disable MySQL strict mode - Turn off MySQL strict mode

Started by Kailash, October 18, 2014, 02:39:41 PM

WordPress Hosting


You may get a message stating that you require to disable MySQL strict mode to install third party script. The common errors are like  column description cannot be null etc.

To disable MySQL strict mode, you will need your server's root or administrative access. You will need to edit "sql-mode" value in your MySQL configuration file (my.ini or my.cnf).

For Linux server, you will need to add the following:


For Windows server, you can follow the below steps:

# The following line will set MySQL strict mode


To disable MySQL strict mode, you can change the above line as follow:


After making the above changes, you will have to restart your MySQL service.