mysql5.7执行sql语句成功，但是报错Err:1055

无论执行什么sql语句都报错：

[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

试了好多方法，最后通过修改my.ini文件彻底解决：

1，运行

SHOW VARIABLES LIKE "sql_mode"；

结果：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，将上述结果的ONLY_FULL_GROUP_BY去掉，赋值到my.ini文件下的[mysqld]下的sql_mode

即：sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SU

 

 重启服务

 

 再次运行，成功！