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):


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
    configure jump server to use SSL for MySQL server 5.7 version
    Viewed 2690 times since Thu, Apr 12, 2018
    How to reset cluster keys in ezeelogin Master-slave Configuration ?
    Viewed 929 times since Fri, Jun 8, 2018
    Configure Ezeelogin to authenticate using Windows_AD(Pam-Ldap) in ubuntu?
    Viewed 2930 times since Wed, Feb 7, 2018
    Integrate OneLogin SSO with jumpserver
    Viewed 612 times since Wed, Aug 14, 2019
    How to configure Yubikey two factor authentication in ssh ?
    Viewed 5735 times since Thu, Jun 15, 2017
    Custom private key / public key pair in ssh gateway Solution
    Viewed 2810 times since Thu, Jun 15, 2017
    Add a server using ssh key pair in ezeelogin
    Viewed 1063 times since Fri, Mar 22, 2019
    How to install free SSL with Let’s Encrypt?
    Viewed 1968 times since Wed, Jul 18, 2018
    How do i configure Ezeelogin to authenticate using OpenLdap(Pam-Ldap) in centos ?
    Viewed 4118 times since Mon, Feb 5, 2018
    How to install ssl certs in jump server(secure connection) ?
    Viewed 2710 times since Mon, Apr 30, 2018