MySql5.x升級(jí)MySql8.x的方法步驟

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
//spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.username=root//你的用戶名.默認(rèn)root
spring.datasource.password=123456//你的密碼.默認(rèn)root

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/sell?characterEncoding=utf-8useSSL=false
//spring.datasource.url=jdbc:mysql://127.0.0.1:3306/sell?useUnicode=truecharacterEncoding=UTF8useSSL=falseserverTimezone=UTC

spring.jpa.show-sql=true

server.context-path=/sell
//server.servlet.context-path=/sell

dependency>
  groupId>mysql/groupId>
  artifactId>mysql-connector-java/artifactId>
  version>8.0.18/version>
/dependency>

com.mysql.cj.jdbc.Driver

# 設(shè)定時(shí)間為東八區(qū)
serverTimezone=GMT%2B8

# 完整url
String url="jdbc:mysql://"+dbHost+":"+dbPort+"/"+dbName+"?"
    + "serverTimezone=GMT%2B8useUnicode=truecharacterEncoding=utf-8"
    + "port="+dbPort+"autoReconnect=true";