This is enabled by default, but you can disable it in one of a couple ways.
First, verify which mode(s) MYSQL is running with:
$ mysql -u root -p -e "SHOWVARIABLESLIKE'sql_mode';"
You can disable strict mode on your MySQL server by running the following command on your Linode's command line:
$ mysql -u root -p -e "SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';"
You can set other values for sql_mode as well. See sysvar sql_mode in the MySQL Documentation for a list.
Then, you can verify that the mode is set by running the following:
$ mysql -u root -p -e "SELECT @@GLOBAL.sql_mode;"
or
Disable it by setting your own SQL_MODE in the my.cnf file, then restart MySQL.
The 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.
Inside my.cnf, 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):
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
You can change the value of sql_mode to NO_ENGINE_SUBSTITUTION to completely disable strict mode, but you may want to look up each mode that is configured before disabling it.
If sql_mode isn't set, you can add it under the [mysqld]
heading, then save the file, and restart MySQL.
Reference:
https://www.linode.com/community/questions/17070/how-can-i-disable-mysql-strict-mode
Article ID: 38
Created On: Mon, Sep 28, 2020 at 1:58 AM
Last Updated On: Mon, Sep 28, 2020 at 1:58 AM
Authored by: Saeed Nobakht [[email protected]]
Online URL: https://www.navel.ir/article/how-can-i-disable-mysql-strict-mode-38.html