mysql主给备赋予权限时报错，MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause

https://www.cnblogs.com/skymyyang/p/7551646.html

 

在my.cnf 里面设置sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'在sql_mode 中去掉only_full_group_by 解决问题！