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

Recommended Providers


Jetpack
Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress Theme

WordPress Hosting Divi WordPress Theme
WPZOOM

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


Kailash

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:

[mysqld]
sql_mode="TRADITIONAL,NO_AUTO_CREATE_USER"

For Windows server, you can follow the below steps:

# The following line will set MySQL strict mode

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

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

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

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