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

Disable MySQL strict mode - Turn off MySQL strict mode

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

Divi WordPress Theme


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.

Divi WordPress Theme