MySQL 5.7.28 - cannot disable ONLY_FULL_GROUP_BY - non-aggregated columns

Question

I have removed ONLY_FULL_GROUP_BY from sql_mode. The following query returns no modes enabled.

SELECT @@GLOBAL.sql_mode;

But still when using group by, I am receiving non-aggregated columns

(this is incompatible with sql_mode=only_full_group_by) error.

Answer 1

Option 1: Remove Globally ONLY_FULL_GROUP_BY using query

mysql> SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
mysql>SET @@sql_mode=REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', '');

Refer: http://johnemb.blogspot.com.ng/2014/09/adding-or-removing-individual-sql-modes.html

Option 2: Set sql_mode to nothing...

mysql> SET GLOBAL sql_mode = '';

Option 3: Remove Globally ONLY_FULL_GROUP_BY from phpmyadmin

1. Open phpmyadmin & select localhost
2. Click on menu Variables & scroll down for sql mode
3. Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.