HostOnNet Blog

Disable MySQL Strict Mode

To disable MySQL strict mode, edit my.cnf file

vi /etc/my.cnf

Find something like following.


Replace with


Now restart MySQL

systemctl restart mysql

Verify MySQL Strict Mode

To verify if you are running MySQL on strict mode or not, run

SELECT @@sql_mode;

If MySQL is not running under strict mode, you see empty result like

boby@hon-pc-01:~$ mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.0.31-MariaDB-0ubuntu0.16.04.2 Ubuntu 16.04

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SELECT @@sql_mode;
| @@sql_mode |
|            |
1 row in set (0.00 sec)

MariaDB [(none)]> 


Posted in MySQL