You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

Docker部署WordPress数据库连接错误及密码修改失效求助

WordPress Docker部署数据库连接错误求助

我在个人Ubuntu 22.04服务器上部署WordPress时,遭遇“建立数据库连接错误”问题。最初的docker-compose配置存在问题,调整后服务可正常运行,但修改MYSQL_PASSWORD为nlkjazjeuzagq后,该错误再次出现,尝试以下操作仍无效:

  • docker-compose up -d
  • 执行docker-compose down && docker image prune -af后重新运行docker-compose up -d

最初的docker-compose配置

version: '3'

services:
  wp-db:
    container_name: wp-mysql_container
    image: mysql:latest
    restart: unless-stopped
    environment:
      TZ: "Europe/Paris"
      MYSQL_ROOT_PASSWORD: ZZZZ
      MYSQL_USER: mywpuser
      MYSQL_DATABASE: mywpdb
      MYSQL_PASSWORD: XXXX
      MYSQL_TCP_PORT: 3307
    volumes:
      - ./wp-db_data:/var/lib/mysql
    ports:
      - 3307:3307
  
  wordpress:
    container_name: wordpress_container
    image: wordpress:latest
    restart: always
    depends_on:
      - wp-db
    ports:
      - 8082:80
    environment:
      WORDPRESS_DB_HOST: wp_db:3307
      WORDPRESS_DB_USER: mywpuser
      WORDPRESS_DB_PASSWORD: XXXX
      WORDPRESS_DB_NAME: mywpdb
    volumes:
      - ./wordpress:/var/www/html
      - ./wordpress_logs:/var/log/apache2

  wp-phpmyadmin:
    container_name: wp-phpmyadmin_container
    image: phpmyadmin:latest
    depends_on:
      - wp-db
    links: 
      - wp-db:wp-db
    ports: 
      - 8083:80
    environment:
      UPLOAD_LIMIT: 100000000
    restart: unless-stopped

volumes:
  wordpress:
  wordpress_logs:
  wp-db:
  wp-db_data:

调整后可正常运行的docker-compose配置

version: '3.8'
services:
  wordpress:
    container_name: wordpress_container
    image: wordpress:latest
    restart: always
    ports:
      - 8082:80
    environment:
      WORDPRESS_DB_HOST: wp_db_mysql
      WORDPRESS_DB_USER: qqqqqqqqqqq
      WORDPRESS_DB_PASSWORD: aaaaaaaaaaaaaa
      WORDPRESS_DB_NAME: yyyyyyyyyyy
    volumes:
      - wp_data:/var/www/htmlqsdgjuytac
  wp_db_mysql:
    container_name: wp_mysql_container
    image: mysql:5.7
    restart: always
    ports:
      - 3307:3307
    environment:
      MYSQL_DATABASE: yyyyyyyyyyy
      MYSQL_ROOT_PASSWORD: bbbbbbbbbb
      MYSQL_USER: qqqqqqqqqqq
      MYSQL_PASSWORD: aaaaaaaaaaaaaa
    volumes:
      - db_data:/var/lib/mysql
  wp_phpmyadmin:
    container_name: wp_phpmyadmin_container
    image: phpmyadmin/phpmyadmin:latest
    depends_on:
      - wp_db_mysql
    ports:
      - 8083:80
    restart: always
    environment:
      PMA_HOST: mysql
      PMA_PORT: 3307
      PMA_ARBITRARY: 1
volumes:
  wp_data:
  db_data:

内容的提问来源于Stack Exchange,提问作者Cqfd83

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.07.09 06:30:10