MYSQL5.7 version sql_mode=only_full_group_by issue

Specific error message:

[ERR] 1055-expression #1 of ORDER by clause are not in GROUP by clause and contains nonaggregated column ' Information_sch Ema. PROFILING. SEQ ' which is not functionally dependent on columns in GROUP by clause; This was incompatible with sql_mode=only_full_group_by

1. View Sql_mode

Select @@. global sql_mode

The values that are queried are:

Only_full_group_by,strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_create_ User,no_engine_substitution

2, remove the only_full_group_by, reset the value.

Set @@. global Sql_mode = ' strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_ Create_user,no_engine_substitution ';

MYSQL5.7 version sql_mode=only_full_group_by issue