How can i disable MySQL strict mode ?

MySQL strict mode is enabled by default. You can disable it by couple of ways.

 

1. To Disable Strict Mode via SQL :

      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;"

 
 
2. Disable Strict Mode via my.cnf:
 
    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.

5 (1)
Article Rating (1 Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Related Articles RSS Feed
    How can i add more than one public key to ezeelogin user ?
    Viewed 1750 times since Wed, Oct 18, 2017
    How to add ssh public key for passwordless authentication in ssh
    Viewed 2819 times since Fri, Sep 1, 2017
    How can i reset the default global key ?
    Viewed 1009 times since Fri, Jun 8, 2018
    add amazon ec2 in jump server or aws jumpbox
    Viewed 3476 times since Tue, May 8, 2018
    Set SSH User Expiry
    Viewed 1621 times since Thu, Sep 20, 2018
    How to install free SSL with Let’s Encrypt?
    Viewed 1968 times since Wed, Jul 18, 2018
    Integrate OneLogin SSO with jumpserver
    Viewed 612 times since Wed, Aug 14, 2019
    Integrate Okta SSO with jumpserver
    Viewed 388 times since Fri, Aug 9, 2019
    configure jump server to use SSL for MySQL server 5.7 version
    Viewed 2690 times since Thu, Apr 12, 2018
    How do i change the web url / uri of my installation?
    Viewed 2205 times since Thu, Jun 15, 2017