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
    How can i add more than one public key to ezeelogin user ?
    Viewed 1111 times since Wed, Oct 18, 2017
    How do i change the authentication from ldap to internal in the database?
    Viewed 1145 times since Thu, Jun 15, 2017
    How to configure Yubikey two factor authentication in ssh ?
    Viewed 3346 times since Thu, Jun 15, 2017
    Enable or Disable or force ssl for the web interface
    Viewed 1599 times since Thu, Jun 15, 2017
    How do i configure Ezeelogin to authenticate using Windows_AD(Pam-Ldap) in centos?
    Viewed 1723 times since Wed, Feb 7, 2018
    How do i change the web url / uri of my installation?
    Viewed 1279 times since Thu, Jun 15, 2017
    How to find a server by its hostname, ip address, very quickly in ezsh shell
    Viewed 857 times since Tue, Mar 27, 2018
    configure jump server to use SSL for MySQL
    Viewed 1654 times since Mon, Apr 30, 2018
    How To Create a Self-Signed SSL Certificate for Nginx on debian
    Viewed 565 times since Mon, Jun 4, 2018
    How to add ssh public key for passwordless authentication in ssh
    Viewed 1522 times since Fri, Sep 1, 2017