[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated

将mysql5.5换成5.7版本之后遇到的问题，在新建表时发生如下错误，在网上看了很多方法得到解决
[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

在my.ini中添加配置，注意是添加在[mysqld]中
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

然后重启mysql服务，重启服务的方式有很多种我直接使用的是net stop mysql停止mysql服务，然后使用net start mysql启动mysql服务，注意需要以管理员身份运行命令行

参考博客：https://blog.csdn.net/u012187452/article/details/82120345