How to set default value for sql_mode?

Question

MySQL

If you go to phpmyadmin and execute a sql query
SELECT @@sql_mode;
Then display the default value
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...
It causes errors on sites, but you can turn it off with this command, that is, clear the value. And then everything is in order, BUT, from time to time the value returns to its original form, how to make it so that, for example, after restarting the server, sql_mode was equal to emptiness ???
SET GLOBAL sql_mode = '';

Answer 1

In parameters --sql-mode='' or in my.cnf

[mysqld] 
...
sql_mode = ''
...

it's written in the docs .