我已经在docker-compose上配置了我的所有服务，但仍然显示“错误建立数据库连接”。

Question

我有个小问题。我正在尝试启动wordpress，它本身通过Nginx服务器连接到我的数据库(mariadb)。但当我进入http://localhost:8080时，它会显示“建立数据库连接时出错”。

这是我的docker-compose.yml：

版本：'3.3‘

服务：

##MariaDB

mariadb：

container_name: mariadb
image: mariadb
volumes:
    - ./mariadb:/var/lib/mysql
environment:
  MYSQL_ROOT_PASSWORD: wordpress
  MYSQL_DATABASE: wordpress
  MYSQL_USER: wordpress
  MYSQL_PASSWORD: wordpress
restart: always

##Wordpress

wordpress：

container_name: wordpress
image: wordpress:fpm-alpine
depends_on:
    - mariadb
volumes:
    - ./wordpress:/var/www/html
environment:
  WORDPRESS_DB_HOST: db:3306
  WORDPRESS_DB_USER: wordpress
  WORDPRESS_DB_PASSWORD: wordpress
  WORDPRESS_DB_NAME: wordpress
restart: always

##Nginx

nginx：

container_name: nginx
image: nginx:alpine
depends_on:
    - wordpress
volumes:
    - ./nginx:/etc/nginx/conf.d
    - ./wordpress:/var/www/html
ports:
    - "8080:80"

这是我的nginx.conf：

服务器{

listen 80;
error_log /var/log/nginx/error.log;
access_log /var/log/nginx/access.log;
root /var/www/html;

location / {
    index index.php;
    try_files $uri $uri/ /index.php?$args;  
}  

location ~ \.php$ {
    fastcgi_split_path_info ^(.+\.php)(/.+)$;
    fastcgi_pass wordpress:9000;
    fastcgi_index index.php;
    include fastcgi_params;
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    fastcgi_param SCRIPT_NAME $fastcgi_script_name;
}

}

Answer 1

您为mariadb指定的ip错误：

container_name: wordpress
image: wordpress:fpm-alpine
depends_on:
    - mariadb
volumes:
    - ./wordpress:/var/www/html
environment:
  WORDPRESS_DB_HOST: db:3306
  WORDPRESS_DB_USER: wordpress
  WORDPRESS_DB_PASSWORD: wordpress
  WORDPRESS_DB_NAME: wordpress
restart: always

已更正：

container_name: wordpress
image: wordpress:fpm-alpine
depends_on:
    - mariadb
volumes:
    - ./wordpress:/var/www/html
environment:
  WORDPRESS_DB_HOST: mariadb:3306
  WORDPRESS_DB_USER: wordpress
  WORDPRESS_DB_PASSWORD: wordpress
  WORDPRESS_DB_NAME: wordpress
restart: always