How do I disable Strict Mode in MySQL? |
Please follow the instructions given below to turn off the MySQL Strict Mode. The latest versions of PHPKB Knowledge Base Management Software does not require MySQL Strict Mode to be turned OFF. It was a requirement for older versions (version 8 or older) of PHPKB software. 1. Disable Strict Mode via my.cnf/my.iniThis method disables it by changing the value of SQL_MODE in my.cnf file (for Linux) OR my.ini file (for windows server) and restarting the MySQL server. my.cnf file can be found in one of a few locations (depending on which distribution you’re using). The most common locations are /etc/my.cnf and /etc/mysql/my.cnf . NOTE: Make the following changes in the my.ini (for Windows Operating System) or my.cnf (for Linux Operating System). Inside that file, look for a heading like [mysqld] and then look for the value of sql_mode. It might look like this (the actual value of sql_mode may vary):
OR 2. To Disable Strict Mode via SQLThis method allows you to disable the strict mode on your MySQL server by running the following command. $ mysql -u root -p -e "SET GLOBAL sql_mode = ’NO_ENGINE_SUBSTITUTION’;" Now, you can verify that the mode is set by running the following: $ mysql -u root -p -e "SELECT @@GLOBAL.sql_mode;" That’s all! Full documentation for setting MySQL modes is available on the Server SQL Modes page in the MySQL Documentation. A description of all of the modes is also available on that page. |
Custom Fields
|
Posted by: Palwinder Singh - March 14, 2017. This article has been viewed 139590 times. |
Online URL: https://www.phpkb.com/kb/article/how-do-i-disable-strict-mode-in-mysql-163.html |
Powered by PHPKB (Knowledge Base Software)