報錯信息

詳細信息

Sat Jan 19 15:48:40 CST 2019 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. ERROR [Druid-ConnectionPool-Create-952370625] - create connection error, url: jdbc:mysql://localhost:3306/ssmtest?characterEncoding=UTF-8, errorCode 0, state 01S00 java.sql.SQLException: The server time zone value '?D1ú±ê×?ê±??' 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.createSQLException(SQLError.java:127)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71)at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1408)at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1464)at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1995) Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value '?D1ú±ê×?ê±??' 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 sun.reflect.GeneratedConstructorAccessor39.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)at java.lang.reflect.Constructor.newInstance(Unknown Source)at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:83)at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128)at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2201)at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2225)at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1391)at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:993)at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:852)... 6 more

解決

這里的mysql版本是：

本地8.0，項目的驅動依賴是8.0.11

MySQL在高版本需要指明是否進行SSL連接

?

找到項目中連接數(shù)據(jù)庫的url的部分，這里是ssm整合時的配置文件xml文件中

<!-- 定義數(shù)據(jù)源Bean --><!-- Druid --><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"><property name="url" value="jdbc:mysql://localhost:3306/ssmtest?characterEncoding=UTF-8&amp;useSSL=true" /><property name="username" value="root" /><property name="password" value="123" /></bean>

在原來的url后面追加 &useSSL=true(如果url是字符串的話)

而這里是xml的配置文件

因為xml文件中&是被禁止的需要用到它的轉義字符"&amp;"

與50位技術專家面對面20年技術見證，附贈技術全景圖

總結

以上是生活随笔為你收集整理的Establishing SSL connection without server's identityverification is not recommended. According to M的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內容還不錯，歡迎將生活随笔推薦給好友。