Docker springboot连接mysql connect refuse

docker-compose配置文章

项目场景：

docker-compose运行jar、mysql容器。在同一网桥下，配置springboot通过域名访问mysql数据库。

---

问题描述

日志报错：springboot cannot connect to mysql connection refused

原因分析：

springboot无法正常访问数据库，非同一网络、端口未开放、防火墙、Jar重新连接数据库配置未重构等。

---

解决方案：

1.是否配置useSSL（高版本的mysql需要指明）

2.查看是否是同一网络下，并且存在容器（证明是否在同一网络）

#查看网络
[root@localhost docker-compose-demo]# docker network ls
NETWORK ID     NAME                                          DRIVER    SCOPE
5bb70c9c8677   bridge                                        bridge    local
9035eb472472   docker-compose-demo_docker-compose-demo-net   bridge    local
3221931118c7   host                                          host      local
478c3b2b1271   none                                          null      local
[root@localhost docker-compose-demo]# docker network inspect 9035eb472472
[
    {
        "Name": "docker-compose-demo_docker-compose-demo-net",
        "Id": "9035eb47247219c3aa76dd476431e1738cdc4f61397745e2a99e1b9848645012",
        "Created": "2022-12-08T06:27:40.512043218-08:00",
        "Scope": "local",
        "Driver": "bridge",
        "EnableIPv6": false,
        "IPAM": {
            "Driver": "default",
            "Options": null,
            "Config": [
                {
                    "Subnet": "192.168.62.56/24",
                    "Gateway": "192.168.62.1"
                }
            ]
        },
        "Internal": false,
        "Attachable": true,
        "Ingress": false,
        "ConfigFrom": {
            "Network": ""
        },
        "ConfigOnly": false,
        "Containers": {
            "7f20a56083fe518e8e6aafb4d5a8385b699151c381705c8e4811ccf53eea67a1": {
                "Name": "mysql",
                "EndpointID": "055f135452b248ac2eabc955ce407e0ee1b9b8569b09f182a6dcded0298c6f6e",
                "MacAddress": "02:42:c0:a8:3e:03",
                "IPv4Address": "192.168.62.3/24",
                "IPv6Address": ""
            },
            "b34ea8492a6f65798369f8aa2430cf9c350b337147eeed2ad38164c606e2d3c0": {
                "Name": "docker-compose-demo02",
                "EndpointID": "cdafff677802ac63a5d9cc9eadbce844c32d501fc2092ec068977c6059a55d0e",
                "MacAddress": "02:42:c0:a8:3e:02",
                "IPv4Address": "192.168.62.2/24",
                "IPv6Address": ""
            }
        },
        "Options": {},
        "Labels": {
            "com.docker.compose.network": "docker-compose-demo-net",
            "com.docker.compose.project": "docker-compose-demo",
            "com.docker.compose.version": "1.29.2"
        }
    }
]

3.查看Jar容器是否可以ping通mysql（证明是否可以访问mysql容器）

[root@localhost docker-compose-demo]# docker ps
CONTAINER ID   IMAGE                 COMMAND                  CREATED      STATUS          PORTS                                                  NAMES
b34ea8492a6f   docker-compose-demo   "java -jar docker-co…"   4 days ago   Up 11 minutes   8082/tcp, 0.0.0.0:8082->8080/tcp, :::8082->8080/tcp    docker-compose-demo02
7f20a56083fe   mysql:8.0.30          "docker-entrypoint.s…"   4 days ago   Up 11 minutes   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql
[root@localhost docker-compose-demo]# docker exec -it b34ea8492a6f bash
root@b34ea8492a6f:/# ping mysql
PING mysql (192.168.62.3): 56 data bytes
64 bytes from 192.168.62.3: icmp_seq=0 ttl=64 time=0.110 ms
64 bytes from 192.168.62.3: icmp_seq=1 ttl=64 time=0.120 ms
64 bytes from 192.168.62.3: icmp_seq=2 ttl=64 time=0.091 ms
^C--- mysql ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max/stddev = 0.091/0.107/0.120/0.000 ms
root@b34ea8492a6f:/# ^C
root@b34ea8492a6f:/# 

4.通过Navicat(证明数据库可以被docker-compose内设置的root用户访问)

5.DockerFile生成镜像是最新的(证明jar生成的容器是最新的)

本人就是因为这个原因弄了很久。之前的mysql配置不存在useSSL=false，添加后，重新运行docker-compose up。不过DockerFile存在缓存，不会重新构建镜像，导致容器不是最新的。

解决方法：