项目场景:
JDBC链接时出现的问题
问题描述:
正常运行的代码
import org.junit.Test;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.SQLException;
import java.util.Properties;
/**
* @author
* @date 2021/4/5 10:34
*/
public class ConnectionTest {
@Test
public void test1() throws SQLException {
//建立驱动实例
Driver driver=new com.mysql.cj.jdbc.Driver();
//定义url链接
String url = "jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=GMT%2B8";
//实例化配置
Properties info=new Properties();
//设置配置中的账号和密码
info.setProperty("user","你的数据库用户名");
info.setProperty("password","你的数据库密码");
//建立连接
Connection connection=driver.connect(url,info);
System.out.println(connection);
}
}
异常运行代码
Mon Apr 05 11:39:39 CST 2021 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.
//机器翻译
Mon Apr 05 11:39:39 CST 2021警告:不建议建立没有服务器身份验证的SSL连接。根据MySQL 5.5.45+, 5.6.26+和5.7.6+的要求,如果没有设置显式选项,必须默认建立SSL连接。为了符合不使用SSL的现有应用程序,verifyServerCertificate属性设置为“false”。您需要通过设置useSSL=false来显式禁用SSL,或者设置useSSL=true并为服务器证书验证提供信任库。
java.sql。SQLException:服务器时区值“Öйú±ê׼ʱ¼ä”无法识别或代表多个时区。如果您想利用时区支持,您必须配置服务器或JDBC驱动程序(通过serverTimezone配置属性)来使用更特定的时区值。
解决方案:将url改为指定要求
String url = “jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=GMT%2B8”;
异常运行代码
Client does not support authentication protocol requested by server; consider upgrading....
机器翻译客户端不支持服务器请求的认证协议;考虑升级……
解决方案:下载一个8.0jdbc导入即可
我的mysql版本为8.0但jdbc驱动为5.1.7
网站:https://downloads.mysql.com/archives/c-j/