注意：mac安装默认没有my.cnf文件，需要自己在/etc目录下新建文件并添加相应配置
pdo链接错误
bin-log开启
参考文档：
MySQL8.0 关闭log-bin 功能
Mac环境MySQL开启binlog
group by
在命令行中执行参考文档中的两个set语句即可，配置文件中添加的无效
set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
参考文档：
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.
网友评论