docker-compose 连接mysql8 数据库使用localhost 引发的错误 DruidDataSource : create connection SQLException

最新推荐文章于 2024-08-22 14:11:18 发布

超哥_cn

最新推荐文章于 2024-08-22 14:11:18 发布

阅读量1k

点赞数 2

本文链接：https://blog.csdn.net/wangchao_cn/article/details/105328027

版权

解决在docker-compose中使用localhost连接MySQL8时出现的通信链接失败问题，改用内网IP（如172.17.0.4）代替localhost即可正常建立连接。

摘要由CSDN通过智能技术生成

解决方案：不要使用localhost或者127.0.0.1，使用内网的ip，就解决了

- SPRING_DATASOURCE_URL=jdbc:mysql://172.17.0.4:3306/davinci0.3?useUnicode=true&characterEncoding=UTF

[Druid-ConnectionPool-Create-1066270324] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://localhost:3306/davinci0.3?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false, errorCode 0, state 08S01

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:172)
   at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(Connect