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 解決問題！