[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

 

mysql5.7版本设置了主从复制之后,出现了如标题的错误.解决办法为:

修改my.cnf,在主mysql和从mysql上都加上这么一句:重启服务:

 

systemctl restart mysqld