Linux下mysql进行group by ，order by查询报错

select userId,count(movieId)
from ratings
group by userId
order by userId

报错：[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

mysql版本：5.7.24-0ubuntu0.16.04.1 (Ubuntu)

解决方案：在/etc/mysql/mysql.conf.d/mysqld.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

添加之前会说mysqld.cnf配置文件是只读不能修改，需要修改权限，

进入到输入mysqld.cnf所在的文件夹下输入

sudo chmod 777 mysqld.cnf

然后完成sql_mode的修改，注意还要恢复权限

sudo chmod 644 mysqld.cnf

然后我又重启了一下mysql，再输入上面命令就不会报错了

--------------------------------华丽丽的-----------------------------------------------------------------------------------------------------------------------

但是order by 并没有按userid顺序出现，查了网上解释原因是因为userid如果是varchar，则会按照varchar排序，改成int类型就可以解决了