MySQL版本为8时,利用JDBC连接数据库时会出现某些问题,下面一一说明:
1 更新驱动包为 mysql-connector-java-8.0.11.jar [https://download.csdn.net/download/szxc0/11423404]
2 jdbc driver 由 com.mysql.jdbc.Driver 改为 com.mysql.cj.jdbc.Driver
3 成功的url例子:jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=UTF-8&userSSL=false&serverTimezone=GMT%2B8
[注]
**1.**url中加上“userSSL=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.”
**2.**url中“serverTimezone=GMT%2B8”,其中GMT%2B8代表东八区