Trying to disable MySQL strict mode

Hi
It seams there is a problem in new cpanel or mysql version

We can not disable strict mode

Code:

[root@server /]# mysqladmin version
mysqladmin  Ver 8.42 Distrib 5.6.30, for Linux on x86_64
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version          5.6.30
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 3 min 3 sec

mysql mode :

Code:

mysql> select @@GLOBAL.sql_mode;
+--------------------------------------------+
| @@GLOBAL.sql_mode                          |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
1 row in set (0.00 sec)

changing my.cnf:

Code:

[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
performance-schema=0
local-infile=0       
max_connections = 750       
max_allowed_packet=268435456
open_files_limit=10000
sql_mode = ""
sql-mode = ""

check sql mode again:

Code:

[root@server /]# service mysql restart
Shutting down MySQL.... SUCCESS!
Starting MySQL. SUCCESS!
[root@server /]# mysql -e 'select @@GLOBAL.sql_mode;'
+--------------------------------------------+
| @@GLOBAL.sql_mode                          |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+

 

This problem exists in original cpanel mysql, original cpanel mariadb and cloudlinux mariadb (installed by mysqlgovernor)

 

MySQL / MariaDB reads the my.cnf configuration files in a preset order. See the SQL docs for full details

As well as an /etc/my.cnf , I found a /usr/my.cnf file that is read after the /etc/my.cnf

I added the line

Code:

sql_mode=""

as the last line of the /usr/my.cnf file and restarted sql and safe mode was disabled, and this configuration survives reboots and updates.

 

Thank you very much
This was my solution.

 

Thanks. This explains why we had 2 clients today asking us to disable it. We refused as we though it was standard with cPanel. Must be some change that occured or is it just coincidence ?

Update: Just noticed its only on our new servers with new cpanel install that it occurs on. The older ones don't have /usr/my.cnf and have the same setup.