Disable Strict mode in Mysql

[jonium]

Hello,
I need to disable Strict mode in Mysql, I tried to do it putting NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION as Sql_mode but at the restart of mysql it is set again so:
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER

After every mysql restart I need to access mysql from command line and do:
SET @@sql_mode = '';
SET @@GLOBAL.sql_mode = '';

Is there a way to definitively set them?

 

[jonium]

Any solution ?

 

[jinfo]

Check /usr/local/mysql/my.conf for the sql_mode setting and comment it in that file as well. Should be all good then!

 

[jonium]

it doesn't exist in my server.
I have done:
[root@a /]# updatedb
[root@a /]# locate my.cnf
/etc/my.cnf
/usr/my.cnf
/usr/local/directadmin/conf/my.cnf

 

[hmaddy]

Screenshot

Captured with Lightshot

prnt.sc

how to turn off mysql_mode and mariadb_mode.

already edited /etc/my.cnf and entered mysqldb="".
But still its on

 

[Zhenyapan]

in [mysqld] section
sql_mode = ""

 

[jonium]

Screenshot

Captured with Lightshot

prnt.sc

how to turn off mysql_mode and mariadb_mode.

already edited /etc/my.cnf and entered mysqldb="".
But still its on

Did you restart MySql after that?