jdbc连接mysql8.0实例及问题

最新推荐文章于 2024-07-17 10:34:02 发布

brz_em

最新推荐文章于 2024-07-17 10:34:02 发布

阅读量3.1k

点赞数

分类专栏： JavaSE 文章标签： jdbc

本文链接：https://blog.csdn.net/qq_35180983/article/details/82184213

版权

本文介绍了在使用JDBC连接MySQL8.0时遇到的时区错误和SSL连接问题，提供了解决方案。通过在URL中设置serverTimezone为GMT或GMT%2B8来调整时区，并设置useSSL=false启用SSL连接。同时，提到了需更新到最新版本的MySQL驱动包。

摘要由CSDN通过智能技术生成

当我们使用之前的方法通过jdbc连接mysql8.0版本时，会出现如下问题提示：

Wed Aug 29 15:38:16 CST 2018 WARN: Establishing SSL connection without server'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 default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLExc