Solutions to SSL and time zone errors when using JDBC to operate the database

Start with my code ：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Test {
    
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
    
     String url="jdbc:mysql://localhost:3306/tsingby";// My database is tsingby
     String user="root";
     String password="root";
     Class.forName("com.mysql.cj.jdbc.Driver");
        Connection connection = DriverManager.getConnection(url, user, password);
        System.out.println(connection);
        connection.close();
    }
}

Say my question again ： stay Java use JDBC operation MySql8.0 The following exception occurred during database

Exception in thread "main" 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.

It means ：

The time zone value of the server does not recognize or represent multiple time zones . If you want to use time zone support , You must configure the server or JDBC The driver （ adopt serverTimezone Configuration properties ）.

At this time 8 Add two parameters to the row , Namely serverTimezone and useSSL, Like this .

String url="jdbc:mysql://localhost:3306/tsingby?serverTimezone=GMT%2B8&useSSL=false";

The modified code ：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Test {
    
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
    
     String url="jdbc:mysql://localhost:3306/tsingby?serverTimezone=GMT%2B8&useSSL=false";
     String user="root";
     String password="root";
     Class.forName("com.mysql.cj.jdbc.Driver");
        Connection connection = DriverManager.getConnection(url, user, password);
        System.out.println(connection);
        connection.close();
    }
}

At this point, it can run perfectly , Print out connection The address of the

[email protected]