docker - phpmyadmin 无法使用 docker-compose : Packets out of order 连接到 mariadb

Question

那么这个 docker-compose.yml 有什么问题？它实际上看起来不错。

但是当我尝试在 http://localhost:8080/index.php 上登录 phpmyadmin 时我得到错误:

Packets out of order. Expected 0 received 1. Packet size=71
mysqli_real_connect(): MySQL server has gone away
mysqli_real_connect(): Error while reading greeting packet. PID=33
mysqli_real_connect(): (HY000/2006): MySQL server has gone away

version: "3"
services:
  db:
    image: mariadb:10.4
    volumes:
      - test_db_data:/var/lib/mysql
    ports:
      - "3306:3306"
    environment:
      MYSQL_DATABASE: test
      MYSQL_USER: test
      MYSQL_PASSWORD: test
      MYSQL_ROOT_PASSWORD: root
    networks:
        - dbtest

  pma:
    image: phpmyadmin/phpmyadmin
    depends_on:
      - db
    ports:
      - 8080:80
    environment:
      - PMA_HOST=db
    networks:
        - dbtest

  adminer:
    image: adminer
    restart: unless-stopped
    ports:
      - 8081:8080
    networks:
      - dbtest

volumes:
  test_db_data:
networks:
  dbtest:

上下文:

• Docker 版本 19.03.3
• docker-compose 版本 1.23.2

更新:
我也添加了管理员，登录也失败了。Mysql 标准错误显示:

[Warning] Aborted connection 9 to db: 'unconnected' user: 'unauthenticated' host: '192.168.32.3' (This connection closed normally without authentication)

Answer 1

我有同样的错误并通过删除数据库卷并重新创建数据库来修复它。不是最好的解决方案。 MySQL 服务器在启动时卡住。

我很幸运，它是一个开发箱上的数据库，所以我必须做的就是运行迁移和重新播种测试数据。