Unknown initial character set index ‘45’ received from server.java.sql.SQLException: Unknown initial character set index ‘45’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.
解决方案:
1.MySQL版本低,需要升级
如果安装的数据库是5以上的版本,需要升级对应版本。
如:copy的项目是5.0.4 ,本地安装的MySQL数据库是版本8以上,需要升级版本。
升级到:
2.修改驱动(MySQL升级,驱动也有变化)
原有驱动
升级为
3.添加字符集和时区(mysql8需要额外配置)
解决!
附加配置代码:
//仓库版本
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
//数据源
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/clouddb01?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
username: root
password: root