原来数据库5.5升级到8.0后,数据库连接配置没有改造成的
1、驱动包要升级为 mysql-connector-java-8.0.11.jar
上面链接访问不了的话到这里下载https://download.csdn.net/download/qq_37874220/87243722
2、JDBC driver 由“com.mysql.jdbc.Driver”改为“com.mysql.cj.jdbc.Driver”
3、url中加上“useSSL=false”。否则会出现以下错误:
“Establishing SSL connection withoutserver's identity verification is not recommended. According to MySQL 5.5.45+,5.6.26+ and 5.7.6+ requirements SSL connection must be established by defaultif explicit option isn't set. For compliance with existing applications notusing SSL the verifyServerCertificate property is set to 'false'. You needeither to explicitly disable SSL by setting useSSL=false, or set useSSL=trueand provide truststore for server certificate verification.”
4、url中加上“serverTimezone=GMT%2B8”(GMT%2B8
代表东八区)
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ny_3line?useUnicode=true&characterEncoding=utf-8&userSSL=false&serverTimezone=GMT%2B8