mysql容器连接被拒绝

Question

我有一个带有mysql服务的docker-compose，当我与mysql工作台建立连接时，它工作得很好，但当我试图连接我的symfony应用程序时，它抛出了一个连接被拒绝的错误。

主机、端口、用户和密码设置正确。

这是我的作文：

version: "3.1"

services:

  mysql:
    build:
      context: .
      dockerfile: docker/mysql/Dockerfile
    restart: always
    working_dir: /app
    volumes:
      - .data:/usr/data
    environment:
      - MYSQL_ROOT_PASSWORD=000000
      - MYSQL_DATABASE=my_database
      - MYSQL_USER=admin
      - MYSQL_PASSWORD=000000
    ports:
      - "3200:3306"

  webserver:
    image: nginx:alpine
    working_dir: /app
    volumes:
      - .:/app
      - ./docker/nginx/nginx.conf:/etc/nginx/conf.d/default.conf
    ports:
      - '8000:80'
    depends_on:
      - php-fpm

  php-fpm:
    build: docker/php-fpm
    working_dir: /app
    volumes:
      - .:/app
      - ./docker/php-fpm/php-ini-overrides.ini:/etc/php/7.3/fpm/conf.d/99-overrides.ini
    links:
      - mysql
    depends_on:
      - mysql

这是mysql的dockerfile：

FROM mysql:5.7


ENV MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
ENV MYSQL_DATABASE=${MYSQL_DATABASE}
ENV MYSQL_USER=${MYSQL_USER}
ENV MYSQL_PASSWORD=${MYSQL_PASSWORD}

COPY ./docker/mysql/my_database.sql /docker-entrypoint-initdb.d/init.sql

EXPOSE 3306

以下是我的symfony配置参数：

parameters:
    database_driver: pdo_mysql
    database_host: mysql
    database_port: 3200
    database_name: my_database
    database_user: admin
    database_password: '000000'

下面是抛出的错误：

"exception": {
        "message": "An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused",
        "code": 0,
        "previous": {
            "message": "SQLSTATE[HY000] [2002] Connection refused",
            "code": 2002,
            "previous": {
                "message": "SQLSTATE[HY000] [2002] Connection refused",
                "code": 2002,
                "trace": [
                    {
                        "namespace": "",
                        "short_class": "",
                        "class": "",
                        "type": "",
                        "function": "",
                        "file": "/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php",
                        "line": 43,
                        "args": []
                    },
                    {
                        "namespace": "",
                        "short_class": "PDO",
                        "class": "PDO",
                        "type": "->",
                        "function": "__construct",
                        "file": "/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php",
                        "line": 43,
                        "args": [
                            [
                                "string",
                                "mysql:host=mysql;port=3200;dbname=my_database;charset=UTF8;"
                            ],
                            [
                                "string",
                                "admin"
                            ],
                            [
                                "string",
                                "000000"
                            ],
                            [
                                "array",
                                []
                            ]
                        ]
                    }

会有什么问题呢？

Answer 1

当您公开mysql容器的端口3306并将其映射到端口3200时，这意味着外部世界应该使用端口3200访问它。但是使用相同网络的其他容器必须使用端口3306。