docker-compose、WordPress和MariaDB、PHP致命錯誤：未捕獲的mysqli_sql

我有一個具有以下docker-compose配置的 WP 專案。當我嘗試連接我的http://localhost以訪問安裝時，我得到 500 并在日志中閱讀了以下內容：

PHP Fatal error: Uncaught mysqli_sql_exception: Connection refused in /var/www/html/web/wp/wp-includes/wp-db.php

我認為 ip 或主機有問題，但奇怪的是 phpmyadmin 作業正常，并且連接mysql沒有問題。

version: '3.9'
services:
  nginx:
    image: nginx:latest
    container_name: ${APP_NAME}-nginx
    ports:
      - '80:80'
    volumes:
      - "./nginx/:/etc/nginx/templates/"
      - ./src:/var/www/html:rw,cached
      - ./certs:/etc/certs
    environment:
      - "NGINX_ENVSUBST_TEMPLATE_SUFFIX=.conf"
      - "DOMAIN=${DOMAIN}"
    depends_on:
      - wordpress
    restart: always

  mysql:
    image: mariadb:latest
    container_name: ${APP_NAME}-mysql
    command: --lower_case_table_names=2
    volumes:
       - './data/db:/var/lib/mysql:delegated'
    environment:
      - MYSQL_ROOT_PASSWORD=${DB_ROOT_PASSWORD}
      - MYSQL_DATABASE=${DB_NAME}
    restart: always
    ports:
      - '3307:3306'

  wordpress:
    build:
      context: .
      dockerfile: Dockerfile
    container_name: ${APP_NAME}-wordpress
    volumes:
      - ./src:/var/www/html:rw,cached
      - ./config/php.ini:/usr/local/etc/php/conf.d/php.ini
    environment:
      XDEBUG_ENABLED: 1
      XDEBUG_CONFIG: remote_host=host.docker.internal
      PHP_IDE_CONFIG: serverName=localhost
    env_file:
      - src/.env
    depends_on:
      - mysql
    restart: always

  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    container_name: ${APP_NAME}-phpmyadmin
    volumes:
      - ./config/phpmyadmin.ini:/usr/local/etc/php/conf.d/phpmyadmin.ini
    environment:
      PMA_HOST: "${DB_HOST}"
      PMA_PORT: 3306
      MYSQL_ROOT_PASSWORD: "${DB_ROOT_PASSWORD}"
    ports:
      - '8083:80'
    links:
      - mysql:mysql

  mailhog:
    container_name: ${APP_NAME}-mailhog
    image: mailhog/mailhog
    ports:
      - "8025:8025"
      - "1025:1025"

  composer:
    image: composer
    container_name: ${APP_NAME}-composer
    working_dir: /var/www/html
    restart: 'no'
    volumes:
      - ./src:/var/www/html:rw,cached

我的 wordpress .env，在其他設定中，設定主機如下：

DB_HOST="mysql:3307"

但我也試過了

DB_HOST="mysql:3306"

或者干脆

DB_HOST="mysql"

你有什么建議嗎？

謝謝。

uj5u.com熱心網友回復：

您的 Wordpress 實體和 MySQL 實體未連接。嘗試添加networksdocker-compose.yml

nginx:
 ...
 networks:
  - your-network-name

mysql:
 ...
 networks:
  - your-network-name

wordpress:
 ...
 networks:
  - your-network-name

并在檔案底部添加：

networks:
 your-network-name:
  driver: bridge

這是配置docker相互連接的方式

轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/394504.html

標籤：php mysql WordPress的码头工人

上一篇：使用頭函式php后如何保存變數

下一篇：用php更新多個復選框

docker-compose、WordPress和MariaDB、PHP致命錯誤：未捕獲的mysqli_sql_exception：連接被拒絕