MySQL版本问题导致项目无法启动问题的解决方案_Mysql

本地项目启动报错

记录一个比较坑的问题,由于mysql版本不同导致了项目启动失败，连接不到数据库等一系列问题。。。

报错原因：

com.alibaba.druid.pool.druiddatasource : init datasource error, url: jdbc:mysql://127.0.0.1:3306/cy_weroom?useunicode=true&characterencoding=utf-8&servertimezone=asia/shanghai

2022-10-07 13:49:34.804 error 25904 --- [           main] com.alibaba.druid.pool.druiddatasource   : init datasource error, url: jdbc:mysql://127.0.0.1:3306/cy_weroom?useunicode=true&characterencoding=utf-8&servertimezone=asia/shanghai

com.mysql.cj.jdbc.exceptions.communicationsexception: communications link failure

the last packet sent successfully to the server was 0 milliseconds ago. the driver has not received any packets from the server.
	at com.mysql.cj.jdbc.exceptions.sqlerror.createcommunicationsexception(sqlerror.java:174)
	at com.mysql.cj.jdbc.exceptions.sqlexceptionsmapping.translateexception(sqlexceptionsmapping.java:64)
	at com.mysql.cj.jdbc.connectionimpl.createnewio(connectionimpl.java:835)
	at com.mysql.cj.jdbc.connectionimpl.<init>(connectionimpl.java:455)
	at com.mysql.cj.jdbc.connectionimpl.getinstance(connectionimpl.java:240)
	at com.mysql.cj.jdbc.nonregisteringdriver.connect(nonregisteringdriver.java:199)
	at com.alibaba.druid.filter.filterchainimpl.connection_connect(filterchainimpl.java:156)
	at com.alibaba.druid.filter.stat.statfilter.connection_connect(statfilter.java:218)
	at com.alibaba.druid.filter.filterchainimpl.connection_connect(filterchainimpl.java:150)
	at com.alibaba.druid.pool.druidabstractdatasource.createphysicalconnection(druidabstractdatasource.java:1560)
	at com.alibaba.druid.pool.druidabstractdatasource.createphysicalconnection(druidabstractdatasource.java:1623)
	at com.alibaba.druid.pool.druiddatasource.init(druiddatasource.java:861)
	at sun.reflect.nativemethodaccessorimpl.invoke0(native method)
	at sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62)
	at sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43)
	at java.lang.reflect.method.invoke(method.java:498)
	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokecustominitmethod(abstractautowirecapablebeanfactory.java:1904)
	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeinitmethods(abstractautowirecapablebeanfactory.java:1846)
	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1774)
	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:593)
	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:515)
	at org.springframework.beans.factory.support.abstractbeanfactory.lambda$dogetbean$0(abstractbeanfactory.java:320)
	at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:222)
	at org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:318)
	at org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:199)
	at org.springframework.beans.factory.config.dependencydescriptor.resolvecandidate(dependencydescriptor.java:277)
	at org.springframework.beans.factory.support.defaultlistablebeanfactory.addcandidateentry(defaultlistablebeanfactory.java:1467)
	at org.springframework.beans.factory.support.defaultlistablebeanfactory.findautowirecandidates(defaultlistablebeanfactory.java:1431)
	at org.springframework.beans.factory.support.defaultlistablebeanfactory.resolvemultiplebeans(defaultlistablebeanfactory.java:1350)
	at org.springframework.beans.factory.support.defaultlistablebeanfactory.doresolvedependency(defaultlistablebeanfactory.java:1209)
	at org.springframework.beans.factory.support.defaultlistablebeanfactory.resolvedependency(defaultlistablebeanfactory.java:1171)
	at org.springframework.beans.factory.support.constructorresolver.resolveautowiredargument(constructorresolver.java:857)
	at org.springframework.beans.factory.support.constructorresolver.createargumentarray(constructorresolver.java:760)
	at org.springframework.beans.factory.support.constructorresolver.autowireconstructor(constructorresolver.java:218)
	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.autowireconstructor(abstractautowirecapablebeanfactory.java:1341)
	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbeaninstance(abstractautowirecapablebeanfactory.java:1187)
	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:555)
	at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:515)
	at org.springframework.beans.factory.support.abstractbeanfactory.lambda$dogetbean$0(abstractbeanfactory.java:320)

我的容器版本mysql版本是5.7.39

本地mysql版本是5.7.20

本地可以但是，但是容器版本不行，于是就想到了是不是版本冲突的问题，因为报的是连接问题

这一段很关键，ssl连接问题，那就是版本问题了

caused by: javax.net.ssl.sslhandshakeexception: no appropriate protocol (protocol is disabled or cipher suites are inappropriate)

解决方案

问题搞清楚了，解决方案为两个

第一个：

在连接后面加上 &usessl=false

jdbc:mysql://127.0.0.1:3306/cy_weroom?useunicode=true&characterencoding=utf-8&servertimezone=asia/shanghai&usessl=false

第二种：

重新pull镜像源，如果不是镜像方式的，则统一版本就可以。

备注：网上扯的那一堆都没有用 wait_timeout=86400 还有时区问题的也是扯淡

容器启动mysql的坑

容器启动mysql的坑：mysql是容器版本启动的要注意挂载宿主机时区，不然默认是utc时区，需要修改时区为宿主机时区，主要会导致你插入的数据时间会比北京时间差8个小时，导致插入数据不对。

两种修改时区的方法：

启动容器时挂载宿主机时区

docker run -p 3306:3306 --name mymysql -v $pwd/conf:/etc/mysql/conf.d -v $pwd/logs:/logs -e tz=asia/shanghai -v $pwd/data:/var/lib/mysql -e mysql_root_password=123456 -d mysql:8.0

第二种进入容器内部修改

#进入容器
docker exec -it 容器名 /bin/bash
#登录mysql
mysql -uroot -p 
#设置时区
set global time_zone = '+8:00';
#立即生效
flush privileges;
#查看时区
show variables like '%time_zone%';

到此这篇关于mysql版本问题导致项目无法启动问题的解决方案的文章就介绍到这了,更多相关mysql版本问题无法启动内容请搜索代码网以前的文章或继续浏览下面的相关文章希望大家以后多多支持代码网！