idea启动springboot项目成功，访问数据库出现异常，如下：
javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
at sun.security.ssl.HandshakeContext.<init>(HandshakeContext.java:171) ~\[na:1.8.0_321\]
at sun.security.ssl.ClientHandshakeContext.<init>(ClientHandshakeContext.java:106) ~\[na:1.8.0_321\]
at sun.security.ssl.TransportContext.kickstart(TransportContext.java:237) ~\[na:1.8.0_321\]
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:405) ~\[na:1.8.0_321\]
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:384) ~\[na:1.8.0_321\]
at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:315) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:352) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.negotiateSSLConnection(NativeAuthenticationProvider.java:777) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:486) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1449) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.NativeSession.connect(NativeSession.java:165) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:955) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance$original$DaazVNV1(ConnectionImpl.java:240) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance$original$DaazVNV1$accessor$qla17fMK(ConnectionImpl.java) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.jdbc.ConnectionImpl$auxiliary$uH1xE8fH.call(Unknown Source) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.StaticMethodsInter.intercept(StaticMethodsInter.java:83) ~\[skywalking-agent.jar:8.7.0\]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect$original$ZJWuyOlG(NonRegisteringDriver.java:199) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect$original$ZJWuyOlG$accessor$q0Ima0up(NonRegisteringDriver.java) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.mysql.cj.jdbc.NonRegisteringDriver$auxiliary$R4w8iv1z.call(Unknown Source) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86) \[skywalking-agent.jar:8.7.0\]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136) ~\[HikariCP-3.2.0.jar:na\]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) ~\[HikariCP-3.2.0.jar:na\]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) ~\[HikariCP-3.2.0.jar:na\]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) ~\[HikariCP-3.2.0.jar:na\]
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) ~\[HikariCP-3.2.0.jar:na\]
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~\[HikariCP-3.2.0.jar:na\]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~\[HikariCP-3.2.0.jar:na\]
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157) ~\[spring-jdbc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) ~\[spring-jdbc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) ~\[spring-jdbc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) ~\[mybatis-spring-2.0.4.jar:2.0.4\]
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) ~\[mybatis-spring-2.0.4.jar:2.0.4\]
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) ~\[mybatis-3.5.4.jar:3.5.4\]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~\[na:1.8.0_321\]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~\[na:1.8.0_321\]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~\[na:1.8.0_321\]
at java.lang.reflect.Method.invoke(Method.java:498) ~\[na:1.8.0_321\]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~\[mybatis-spring-2.0.4.jar:2.0.4\]
at com.sun.proxy.$Proxy76.selectOne(Unknown Source) ~\[na:na\]
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159) ~\[mybatis-spring-2.0.4.jar:2.0.4\]
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:144) ~\[mybatis-3.5.4.jar:3.5.4\]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) ~\[mybatis-3.5.4.jar:3.5.4\]
at com.sun.proxy.$Proxy77.selectByPrimaryKey(Unknown Source) ~\[na:na\]
at com.pimee.service.impl.UserService.getUserById(UserService.java:19) ~\[classes/:na\]
at com.pimee.service.impl.UserService$$FastClassBySpringCGLIB$$f8bfb11c.invoke(<generated>) ~\[classes/:na\]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~\[spring-core-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) ~\[spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at com.pimee.service.impl.UserService$$EnhancerBySpringCGLIB$$876d2bc5.getUserById(<generated>) ~\[classes/:na\]
at com.pimee.controller.UserController.get$original$cjLFGQkp(UserController.java:24) ~\[classes/:na\]
at com.pimee.controller.UserController.get$original$cjLFGQkp$accessor$jbcUUJc3(UserController.java) ~\[classes/:na\]
at com.pimee.controller.UserController$auxiliary$f0cRbU4m.call(Unknown Source) ~\[classes/:na\]
at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86) \[skywalking-agent.jar:8.7.0\]
at com.pimee.controller.UserController.get(UserController.java) ~\[classes/:na\]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~\[na:1.8.0_321\]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~\[na:1.8.0_321\]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~\[na:1.8.0_321\]
at java.lang.reflect.Method.invoke(Method.java:498) ~\[na:1.8.0_321\]
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~\[spring-webmvc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) ~\[spring-webmvc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) ~\[spring-webmvc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~\[spring-webmvc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) ~\[spring-webmvc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~\[spring-webmvc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~\[spring-webmvc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~\[spring-webmvc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~\[spring-webmvc-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~\[tomcat-embed-websocket-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~\[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE\]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) ~\[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.StandardHostValve.invoke$original$kO9NxehN(StandardHostValve.java:139) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.StandardHostValve.invoke$original$kO9NxehN$accessor$w1FtTSoO(StandardHostValve.java) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.StandardHostValve$auxiliary$pxmiu9VX.call(Unknown Source) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86) \[skywalking-agent.jar:8.7.0\]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) \[na:1.8.0_321\]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) \[na:1.8.0_321\]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) \[tomcat-embed-core-9.0.17.jar:9.0.17\]
at java.lang.Thread.run(Thread.java:750) \[na:1.8.0_321\]
- 原来的jdbcUrl：
jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&serverTimezone=GMT%2B8
-
解决方案：jdbcUrl添加
useSSL=false -
最后修改为
jdbc:mysql://localhost:3306/test?useSSL=false&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&serverTimezone=GMT%2B8
