mysqlmysql-5.7mysql-error-1055

Error after upgrade MySQL 5.0 to 5.7

I have upgraded MySQL from version 5.0.67 to 5.7.19. But every time I run MySQL query, I get this error.

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

I have checked to the PROFILING table in information_schema database, but it contains no data.

My MySQL sql_mode is ANSI.

Solution

  • Try changing the SQL mode :

    Remove the 'only_full_group_by' option. For MySQL 5.7 this is set as Default.