Docker中的phpMyAdmin实现不起作用

鲍勃

我正在尝试将Laravel项目容器化。我的docker-compose.yml中有以下服务

  1. laravel_app
  2. 数据库
  3. Nginx的
  4. phpmyadmin

除了PHPMyAdmin之外,其他所有程序都可以正常运行。它已构建并确实为phpMyAdmin登录页面提供服务,但是输入凭据时出现以下错误。

Cannot log in to the MySQL server

mysqli::real_connect(): php_network_getaddresses: getaddrinfo failed: No address associated with hostname

mysqli::real_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: No address associated with hostname

错误的屏幕截图

这是我的docker-compose.yml代码段,其中包括我的数据库服务和phpmyadmin服务

#The Database

  database:
    container_name: mysql_database
    image: mysql:5.7
    volumes:
      - dbdata:/var/lib/mysql
    environment:
      - "MYSQL_DATABASE=dev-db"
      - "MYSQL_USER=phpmyadmin"
      - "MYSQL_PASSWORD=phpmyadmin"
      - "MYSQL_ROOT_PASSWORD=123456"
    ports:
      - 8991:3306


#PHPMyAdmin Service
  phpmyadmin:
    container_name: phpmyadmin
    image: phpmyadmin/phpmyadmin
    ports:
    - "8992:80"
    depends_on: 
      - database
    environment:
      - "PMA_HOST:database"
      - "MYSQL_USER:phpmyadmin"
      - "MYSQL_PASSWORD:phpmyadmin"
      - "MYSQL_ROOT_PASSWORD:123456"
      - "UPLOAD_LIMIT:3000000000"


# redis

  cache:
    image: redis:3.0-alpine


volumes:
  dbdata:
Fominykh Maxim

为此,您至少需要创建一个桥接网络并将phpmyadmin和您的数据库连接到该网络。

这样的事情应该起作用:

version: "3"
volumes:
  dbdata:
networks:
  backend:
    driver: bridge
services:
  database:
    container_name: mysql_database
    image: mysql:5.7
    volumes:
      - dbdata:/var/lib/mysql
    environment:
      - "MYSQL_DATABASE=dev-db"
      - "MYSQL_USER=phpmyadmin"
      - "MYSQL_PASSWORD=phpmyadmin"
      - "MYSQL_ROOT_PASSWORD=123456"
    ports:
      - 8991:3306
    networks:
      - backend

  phpmyadmin:
    container_name: phpmyadmin
    image: phpmyadmin/phpmyadmin
    ports:
      - "8992:80"
    depends_on:
      - database
    environment:
      - "PMA_HOST=database"
      - "MYSQL_USER=phpmyadmin"
      - "MYSQL_PASSWORD=phpmyadmin"
      - "MYSQL_ROOT_PASSWORD=123456"
      - "UPLOAD_LIMIT=3000000000"
    networks:
      - backend
  

另外我也不建议公开数据库端口

编辑:固定泊坞窗组成文件

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章