MySql5.x升级MySql8.x非常简单,一般来说只需要操作两个步骤即可

1. 替换新的jar包

<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.18</version></dependency>2. 替换新驱动类

com.mysql.cj.jdbc.Driver3. 替换新url连接,需要指定时区

# 设定时间为东八区serverTimezone=GMT%2B8# 完整urlString url="jdbc:mysql://"+dbHost+":"+dbPort+"/"+dbName+"?" + "serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8" + "&port="+dbPort+"&autoReconnect=true";