com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
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.
3.java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time
时区问题导致报错;
有人说直接执行查询:set GLOBAL time_zone='+8:00';但这样只是暂时解bao决问题,下次打开工程还会报错!
最终解决方式将数据库连接改为:url=jdbc:mysql://127.0.0.1:3306/MyDatabase+?serverTimezone=GMT%2B8
这里加上了时区 GMT%2B8 代表东八区
如:
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/user?serverTimezone=GMT", "root", "775633");
System.out.println("connection--->"+true);
} catch (Exception e) {
// TODO Auto-generated catch block
System.out.println("connection--->"+false);
e.printStackTrace();
}