我最近从XAMPP切换到Docker for PHP Development,并设法让我的项目运行起来。该项目在XAMPP上运行良好,但由于任何原因,数据库不断损坏,因此切换到Docker。这个问题可能以前有人问过,但到目前为止我还没有找到答案。
我有一个登录页面,在那里我将数据提交给一个php脚本,该脚本与数据库建立连接,在这一部分中,它遇到了一个异常:
61SQLSTATE[HY000] [2002] Connection refused61SQLSTATE[HY000] [2002] Connection refused
Warning: Cannot modify header information - headers already sent by (output started at /var/www/inc/cDBConnection.inc.php:61)我有一个docker-compose.yml文件:
version: "3.2"
services:
php:
build: './php/'
networks:
- backend
volumes:
- ./project/:/var/www/html/
- ./inc/:/var/www/inc/
apache:
build: './apache/'
depends_on:
- php
- mysql
networks:
- frontend
- backend
ports:
- "8080:80"
volumes:
- ./project/:/var/www/html/
mysql:
image: mysql:5.6.40
ports:
- "3306:3306"
volumes:
- ./db:/var/lib/mysql
networks:
- backend
environment:
- MYSQL_ROOT_PASSWORD=password
networks:
frontend:
backend:apache文件夹中的Dockerfile:
FROM httpd:2.4.33-alpine
RUN apk update; \
apk upgrade;
# Copy apache vhost file to proxy php requests to php-fpm container
COPY apache.conf /usr/local/apache2/conf/apache.conf
RUN echo "Include /usr/local/apache2/conf/apache.conf" \
>> /usr/local/apache2/conf/httpd.confphp文件夹中的Dockerfile:
FROM php:7.2.7-fpm-alpine3.7
RUN apk update; \
apk upgrade;
RUN docker-php-ext-install pdo pdo_mysql mysqliDBConnection.php:
$this->_config = $databaseConfig;
$dsn = "" .
$this->_config['driver'] .
":host=" . $this->_config['host'] .
";dbname=" . $this->_config['dbname'];
try {
$this->dbc = new PDO( $dsn, $this->_config[ 'username' ], $this->_config[ 'password' ] );
} catch( PDOException $e ) {
echo __LINE__.$e->getMessage(); // here i run into this exception
}我假设我在dockerfile中缺少一些扩展名,但是如果我通过mysql查询浏览器登录,我可以作为root用户登录。对于这个项目,我有另一个用户,这个用户是我用以下命令创建的:
CREATE USER 'sec_user'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE ON `project`.* TO 'sec_user'@'localhost';当我尝试用这个用户登录时,我得到了一个错误“访问被拒绝”,所以我遵循了checked with:
SELECT user, host FROM mysql.user;
UPDATE mysql.user SET host='%' WHERE user='sec_user';
FLUSH PRIVILEGES而且登录可以使用查询浏览器,但在前台我无法登录。有人知道这里的问题是什么吗?
发布于 2019-09-03 03:45:51
我找到了这个问题的解决方案。凭据通过环境变量传递,连接到localhost或127.0.0.1将不起作用。凭据应该在dockerfile中:
environment:
- MYSQL_ROOT_PASSWORD=password
- MYSQL_DATABASE=test_db
- MYSQL_USER=sec_user
- MYSQL_PASSWORD=password然后在DBConnection.php中访问这些内容,如下所示:
'host' => "mysql", //this is from the dockerfile, docker does the mapping for you
'port' => '3306',
'dbname' => $_ENV["MYSQL_DATABASE"],
'username' => $_ENV["MYSQL_USER"],
'password' => $_ENV["MYSQL_PASSWORD"]并成功连接!
https://stackoverflow.com/questions/57749294
复制相似问题