phpstudy8.1.0.1的mysql5.7.26不能使用groupby
会报错
[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vchat.file_excel_tab.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
查了资料，需要把my.cnf的sql_mode，修改，但是修改后mysql报错，无法启动
这是资料：https://blog.csdn.net/chai1230/article/details/89514482
无法启动报错：
2020-04-14T04:29:56.815000Z 0 [Warning] option 'log_error_verbosity': unsigned value 0 adjusted to 1
2020-04-14T04:29:56.815000Z 0 [ERROR] D:\phpstudy_pro\COM\..\Extensions\MySQL5.7.26\\bin\mysqld.exe: Error while setting value ''STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';' to 'sql_mode'
2020-04-14T04:29:56.815000Z 0 [ERROR] Aborting
