关于java链接MySQL出现的问题及调试
环境
eclipse版本:eclipse-committers-2019-06-R-win32-x86_64
mysql版本:MySQL Server 8.0
mysql驱动版本:mysql-connector-java-8.0.18
初始代码:
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
public class ConnectionClass {
public static void main(String[] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/sss";
String user="root";
String pwd="123";
Connection conn= DriverManager.getConnection(url, user, pwd);
System.out.println(conn);
}
}
报错信息
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.
不建议在没有服务器身份验证的情况下建立SSL连接。根据mysql 5.5.45+、5.6.26+和5.7.6+的要求,如果未设置显式选项,则默认情况下必须建立ssl连接。对于不使用SSL的现有应用程序,ValuyServer证书属性设置为“false”。您需要通过设置usessl=false显式禁用ssl,或者设置usessl=true并为服务器证书验证提供信任存储。
String url="jdbc:mysql://localhost:3306/sss";这句代码后加"?useSSL=false"
接下来还会报错
报错信息
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.作者:Dmego
java.sql.sqlexception:无法识别服务器时区值“____戆戆戆戆戆戆戆”或表示多个时区。如果要利用时区支持,则必须配置服务器或JDBC驱动程序(通过ServerTimeZone配置属性)以使用更具体的时区值。
解决此问题要把时区问题解决,即:serverTimezone=GMT%2B8
String url="jdbc:mysql://localhost:3306/sss?useSSL=false&serverTimezone=GMT%2B8";
注意:
Class.forName("com.mysql.jdbc.Driver");
必须改一下,改成:
Class.forName("com.mysql.cj.jdbc.Driver");
最后即可连接mysql成功