无法登录到MySQL服务器

Question

当我试图访问phpmyadmin时，我会得到以下错误。

1 mysqli::real_connect()：php_network_getaddresses: getaddrinfo失败:名称解析临时失败

2 mysqli::real_connect()：(HY000/2002)：php_network_getaddresses: getaddrinfo失败:名称解析临时失败

version: '3.7'

services:
  mysqldb:
    container_name: mysqldb
    image: mysql
    command: --default-authentication-plugin=mysql_native_password
    environment:
      MYSQL_ROOT_PASSWORD: Root193782
      MYSQL_DATABASE: admin
    ports:
      - 3306:3306
    volumes:
      - /data/mysql:/var/lib/mysql
    networks:
      - mysql-net

  phpmyadmin:
    container_name: phpmyadmin
    image: phpmyadmin
    environment:
      MYSQL_ROOT_PASSWORD: Root193782
    ports:
      - 8080:80
    volumes:
      - /data/php/admin/uploads.ini:/usr/local/etc/php/conf.d/php-phpmyadmin.ini
    networks:
      - mysql-net

networks:
  mysql-net:
    driver: bridge

Answer 1

==================================================

我设法解决了这个问题，传递了下面的环境变量。下面

version: '3.7'

networks:
  mysql-net:
    driver: bridge

services:
  mysqldb:
    container_name: mysqldb
    image: mysql
    command: --default-authentication-plugin=mysql_native_password
    environment:
      MYSQL_ROOT_PASSWORD: Root193782
      MYSQL_DATABASE: admin
    ports:
      - 3306:3306
    volumes:
      - /data/mysql:/var/lib/mysql
    networks:
      - mysql-net

  phpmyadmin:
    container_name: phpmyadmin
    image: phpmyadmin/phpmyadmin:latest
    environment:
      - PMA_HOSTS=mysqldb
      - PMA_ARBITRARY=1
      - PMA_USER=root
      - PMA_PASSWORD=Root193782
    ports:
      - 8080:80
    volumes:
      - /data/php/admin/uploads.ini:/usr/local/etc/php/conf.d/php-phpmyadmin.ini
    networks:
      - mysql-net