mysql column which is not functionally dependent GROUP BY clause

Linux下使用mysql5.7出现这个错误：mysql column which is not functionally dependent GROUP BY clause

解决办法：

1、首先查询

show variables like "sql_mode";

2、复制sql-mode的Value,添加到 /ect/my.cnf配置文件中的[mysqld]下.

3、然后重启数据库

 systemctl restart mysqld.service