mysql - Docker - PHP/MySQL - php_network_getaddresses：getaddrinfo 失败：名称或服务未知

Question

我有以下 docker-compose.yml，主要是从一些教程中复制的（https://medium.com/@romaricp/the-perfect-kit-starter-for-a-symfony-4-project-with-docker-and -php-7-2-fda447b6bca1）：

version: '3'
services:
  apache:
    build: .docker/apache
    container_name: sf4_apache
    ports:
      - 80:80
      - 443:443
    volumes:
      - .docker/config/vhosts:/etc/apache2/sites-enabled
      - .:/home/wwwroot/sf4:cached
    depends_on:
      - php

  mysql:
    image: mysql:5.7
    container_name: sf4_mysql
    command: "--default-authentication-plugin=mysql_native_password"
    restart: always
    ports:
      - 3306:3306
    volumes:
      - .docker/data/db:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: sf4
      MYSQL_USER: sf4
      MYSQL_PASSWORD: sf4

  php:
    build: .docker/php
    container_name: sf4_php
    volumes:
      - .:/home/wwwroot/sf4
    environment:
      - maildev_host=sf4_maildev
    depends_on:
      - maildev
      - mysql

  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    container_name: sf4_phpmyadmin
    environment:
      PMA_HOST: sf4_mysql
      PMA_PORT: 3306
    ports:
      - 8080:80
    links:
      - mysql

  maildev:
    image: djfarrelly/maildev
    container_name: sf4_maildev
    ports:
      - 8001:80

现在我的问题是，我无法连接到 MySQL。无论是 PHP 还是 PhpMyAdmin。我尝试了以下连接字符串，但它们都不起作用：

DATABASE_URL=mysql://root:root@mysql:3306/sf4
DATABASE_URL=mysql://sf4:sf4@mysql:3306/sf4
DATABASE_URL=mysql://root:root@sf4_mysql:3306/sf4
DATABASE_URL=mysql://sf4:sf4@sf4_mysql:3306/sf4
... and hundreds more

但我总是得到：

PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known

或者

SQLSTATE[HY000] [2002] No route to host

或者

SQLSTATE[HY000] [2002] Connection refused 

标签： mysqldockersymfonydocker-compose

Answer 1

感谢@emix 和@LinPy，他们在评论中帮助了我，这里是固定配置：

version: '3'
services:
  apache:
    build: .docker/apache
    container_name: sf4_apache
    ports:
      - 80:80
      - 443:443
    volumes:
      - .docker/config/vhosts:/etc/apache2/sites-enabled
      - .:/home/wwwroot/sf4:cached
    depends_on:
      - php

  mysql:
    image: mysql:5.7
    container_name: sf4_mysql
    #command: "--default-authentication-plugin=mysql_native_password"
    #restart: always
    ports:
      - 3306:3306
    volumes:
      - .docker/data/db:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: sf4
      MYSQL_USER: sf4
      MYSQL_PASSWORD: sf4

  php:
    build: .docker/php
    container_name: sf4_php
    volumes:
      - .:/home/wwwroot/sf4
    environment:
      - maildev_host=sf4_maildev
    depends_on:
      - maildev
      - mysql

  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    container_name: sf4_phpmyadmin
    environment:
      PMA_HOST: mysql
      PMA_PORT: 3306
    ports:
      - 8080:80
    links:
      - mysql

  maildev:
    image: djfarrelly/maildev
    container_name: sf4_maildev
    ports:
      - 8001:80

连接字符串：

DATABASE_URL=mysql://sf4:sf4@mysql/sf4