Web Hosting Forum - A Web Hosting community for Webmasters


Divi WordPress Theme

Author Topic: Disable MySQL strict mode - Turn off MySQL strict mode  (Read 987 times)

0 Members and 1 Guest are viewing this topic.

Offline Kailash

  • Administrator
  • Web Hosting Master
  • *****
  • Posts: 601
  • iTrader: +153/-0
    • View Profile
Disable MySQL strict mode - Turn off MySQL strict mode
« on: October 18, 2014, 02:39:41 PM »
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
Tags:
 

Related Topics

  Subject / Started by Replies Last post
8 Replies
3305 Views
Last post July 12, 2012, 12:29:05 PM
by madelinekim
1 Replies
1909 Views
Last post April 13, 2008, 07:15:49 PM
by John
1 Replies
3510 Views
Last post December 22, 2011, 05:52:05 PM
by wilsondavid
2 Replies
3315 Views
Last post November 25, 2009, 07:02:28 PM
by kvchosting
2 Replies
1674 Views
Last post June 15, 2013, 11:26:37 AM
by Web_news