Unable to get rid of sql_mode ONLY_FULL_GROUP_BY on ubuntu 16.04
I am trying to remove the sql_mode = ONLY_FULL_GROUP_BY in a persistent way. Issuing the following command I can do it for this sessison
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Then I tried to remove it permanently by modifying /etc/mysql/my.cnf /etc/mysql/mysql.cnf /etc/mysql/mysql.conf.d/mysqld.cnf adding a section
[mysqld]
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
However when I restart the mysql, teh ONLY_FULL_GROUP_BY mode is there. I am running out of options.
Does anyone can provide a little bit of light here? Thank you.