PHP容器无法连接到MySQL容器

Question

我正试图从PHP容器连接到容器化的MySQL数据库，虽然同一网络上的所有容器都是如此，但问题是，当我点击http://localhost:8080/dbTest.php尽管我已经使用mysql-u root-p检查了凭证是否正确，并且演示数据库是否存在

我在mysql log mbind中看到这条消息：不允许的操作可能相关？
谢谢

Apache Dockerfile

FROM httpd:latest
RUN apt-get update
RUN apt-get upgrade
COPY demo.apache.conf /usr/local/apache2/conf/demo.apache.conf
RUN echo "Include /usr/local/apache2/conf/demo.apache.conf"  >> /usr/local/apache2/conf/httpd.conf

cmd:docker run-p 8080:80/tcp-v/home/hmalabeh/tutorial/docker/lamp/files/：/usr/local/apache2/htdocs/--link=php--名称apache--网络后端-i 8f704f51962d

PHP Dockerfile

FROM php:7.2.7-fpm-alpine3.7
RUN docker-php-ext-install mysqli
RUN docker-php-ext-enable mysqli
RUN docker-php-ext-install pdo pdo_mysql
EXPOSE 9000

cmd： docker run-p 9000:9000-v /home/hmalabeh/tutorial/docker/lamp/files/：/var/www/html/--name php--network backend-i 1cc049496b03

MySQL Dockerfile

FROM mysql:latest
RUN apt-get update
RUN apt-get upgrade
ENV MYSQL_ROOT_PASSWORD=root

cmd:docker run-p 3306:3306-p 33060:33060--名称mysql--网络后端--link=php-i 7bb7d4985301

dbTest.php

<?php
class DBConnect
{
    private $dsn = "mysql:dbname=demo;host=127.0.0.1;port=3306;";
    private $dbUsername = "root";
    private $dbPassword = "root";
    private $conn;

    public function connect()
    {
        try {
            echo 'Attempt Connection.     ';
            $this->conn = new PDO($dsn, $dbUsername, $dbPassword);

            echo 'Connected successfully.      ';
        } catch (PDOException $exception) {
            echo 'Connection failed: ' . $exception->getMessage();
        }
        return $this->conn;
    }
}


$co = new DBConnect();
$co->connect();
?>

我的运行容器

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                                              NAMES
9639160c0824        8f704f51962d        "httpd-foreground"       2 hours ago         Up 2 hours          0.0.0.0:8080->80/tcp                               apache
38e630a9cb01        7bb7d4985301        "docker-entrypoint.s…"   2 hours ago         Up 2 hours          0.0.0.0:3306->3306/tcp, 0.0.0.0:33060->33060/tcp   mysql
c7f6e8db26a9        1cc049496b03        "docker-php-entrypoi…"   2 hours ago         Up 2 hours          0.0.0.0:9000->9000/tcp                             php




Answer 1

我忘记添加$-

<?php
class DBConnect
{
    private $dsn = "mysql:host=mysql;dbname=demo;port=3306;charset=utf8";
    private $dbUsername = "root";
    private $dbPassword = "root";
    private $conn;

    public function connect()
    {
        try {
            echo 'Attempt Connection.     ';
            $this->conn = new PDO($this->dsn, $this->dbUsername, $this->dbPassword);

            echo 'Connected successfully.      ';
        } catch (PDOException $exception) {
            echo 'Connection failed: ' . $exception->getMessage();
        }
        return $this->conn;
    }
}


$co = new DBConnect();
$co->connect();
?>

Answer 2

匿名用户

您是否在mySql中启用了远程访问？

nano/etc/mysql/mysql.conf.d/mysqld.cnf

绑定地址=127.0.0.1替换为绑定地址=0.0.0.0

Answer 3

使用容器的名称将host添加到DSN，因为它们在同一个网络中：

private $dsn = "mysql:host=mysql;dbname=demo;port=3306;";

参考