springboot mysql踩过的坑

服务的环境经常变更，水土不服导致程序跑不起来。所有问题均来自配置问题。

1、this is incompatible with sql_mode=only_full_group_by......

MySQL版本问题

https://blog.csdn.net/qq_42175986/article/details/82384160

修改配置文件：

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服务，顺利解决。 

或者临时修改：

select @@GLOBAL.sql_mode;

set@@GLOBAL.sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

 

2、java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

MySQL内部字符集编码不统一

https://blog.csdn.net/hqyhqyhq