无法连接容器mariadb和phpmyadmin

Question

当我试图登录到phpmyadmin时，我得到了错误"mysqli::real_connect()：(HY000/2002)：没有这样的文件或目录“。我验证了我可以使用mysql -h 127.0.0.1 -p 3306 -u根-P从本地主机连接到DB容器。下面是我的停靠-撰写文件：

    version: "3.7"
    ########################### SECRETS
    secrets:
      mysql_root_password:
        file: $DOCKERDIR/secrets/mysql_root_password
    
    ########################### SERVICES
    services:
    # Portainer - WebUI for Containers
      portainer:
        container_name: portainer
        image: portainer/portainer-ce:latest
        restart: unless-stopped
        command: -H unix:///var/run/docker.sock
        security_opt:
          - no-new-privileges:true
        ports:
          - "$PORTAINER_PORT:9000"
        volumes:
          - /var/run/docker.sock:/var/run/docker.sock:ro
          - $DOCKERDIR/portainer/data:/data
        environment:
          - TZ=$TZ
    
     # MariaDB - MySQL Database
      db:
        container_name: db
        image: linuxserver/mariadb:latest
        restart: always
        security_opt:
          - no-new-privileges:true
        ports:
          - "$MARIADB_PORT:3306"
        volumes:
          - $DOCKERDIR/mariadb/data:/config
        environment:
          - PUID=$PUID
          - PGID=$PGID
          - TZ=$TZ
          - FILE__MYSQL_ROOT_PASSWORD=/run/secrets/mysql_root_password
        secrets:
          - mysql_root_password
    
    # phpMyAdmin - Database management
      phpmyadmin:
        image: phpmyadmin/phpmyadmin:latest
        container_name: phpmyadmin
        restart: unless-stopped
        depends_on:
          - db
        security_opt:
          - no-new-privileges:true
        ports:
          - "$PHPMYADMIN_PORT:80"
        volumes:
          - $DOCKERDIR/phpmyadmin:/etc/phpmyadmin
        environment:
          - PMA_HOST=db
          #- PMA_ARBITRARY=1
          - MYSQL_ROOT_PASSWORD_FILE=/run/secrets/mysql_root_password
        secrets:
          - mysql_root_password
    
    # Dozzle - Real-time Docker Log Viewer
      dozzle:
        image: amir20/dozzle:latest
        container_name: dozzle
        restart: unless-stopped
        security_opt:
          - no-new-privileges:true
        ports:
          - "$DOZZLE_PORT:8080"
        environment:
          DOZZLE_LEVEL: info
          DOZZLE_TAILSIZE: 300
          DOZZLE_FILTER: "status=running"
        volumes:
          - /var/run/docker.sock:/var/run/docker.sock

对于我的生活，我不知道我做错了什么，登录到Phpmyadmin。有人能解释我的错误或错误并指出正确的方向吗？谢谢

Answer 1

我发现了这个问题，首先我在pphpmyadmin部分设置了网络，而不是db，一旦我将网络语句添加到db部分，我就能够连接了。