MariaDB Docker错误2002当试图连接到数据库从应用程序

Question

我有一个问题，我的应用程序，当尝试从php应用程序在cli数据库连接我收到这个错误：

错误2002（HY000）：无法通过套接字“/var/run/mysqld/mysqld”连接到本地MySQL服务器。袜子（111）

当我运行网站时，我得到：

[2002]连接拒绝（SQL：从会话中选择*，其中id=TKks6w5zbHk8bZsm6BEgFyKLJGXj05eyYHQfJsaB限制1）

我用docker compose设置了docker图像。yml和。Dockerfile还提供了带有应用程序的nginx文件夹。conf和mysql文件夹与我的。cnf我会把这些放在这里

version: '3.4'

services:
  mariadb: 
    image: mariadb/server:latest
    container_name: db
    restart: unless-stopped
    tty: true
    ports: 
      - "3306:3306"
    environment:
      MYSQL_DATABASE: PiApp
      MYSQL_ROOT_PASSWORD: rootpass
      SERVICE_TAGS: dev
      SERVICE_NAME: mysql
    volumes: 
      - dbdata:/var/lib/mysql/
      - .\mysql/my.cnf:/etc/mysql/my.cnf
    networks: 
      - Pi-Wallet-Network

  phpmyadmin: 
    image: phpmyadmin/phpmyadmin
    ports:
      - "8080:80"
    restart: unless-stopped
    environment:
      - PMA_HOST=mariadb
    links:
      - mariadb
    networks: 
      - Pi-Wallet-Network

  app:
    image: php:7.4-fpm
    build:
      context: .
      dockerfile: ./Dockerfile
    environment:
      NODE_ENV: production
      SERVICE_NAME: app
      SERVICE_TAGS: dev
    working_dir: /var/www
    volumes:
      - .\:/var/www
      - .\php/local.ini:/usr/local/etc/php/conf.d/local.ini
    links:
      - mariadb
    networks:
      - Pi-Wallet-Network

  webserver:
    image: nginx:latest
    container_name: webserver 
    tty: true
    ports: 
      - "80:80"
      - "443:443"
    volumes:
      - .\:/var/www
      - .\nginx/conf.d/:/etc/nginx/conf.d/
    links:
      - mariadb
    networks:
      - Pi-Wallet-Network

networks:
  Pi-Wallet-Network:
    driver: bridge

volumes:
  dbdata:
   driver: local

我的Dockerfile：

FROM php:7.4-fpm
# FROM mariadb/server:latest

# Copy composer.lock and composer.json into the working directory
COPY composer.lock composer.json /var/www/

# Set working directory
WORKDIR /var/www/

# Install dependencies for the operating system software
RUN printf '#!/bin/sh\nexit 0' > /usr/sbin/policy-rc.d
RUN apt-get update && apt-get upgrade -y 
RUN apt-get install -y mariadb-server 
RUN apt-get install -y build-essential 
RUN apt-get install -y libpng-dev
RUN apt-get install -y libjpeg-dev
RUN apt-get install -y libjpeg62-turbo-dev
RUN apt-get install -y libfreetype6-dev 
RUN apt-get install -y locales 
RUN apt-get install -y zip 
RUN apt-get install -y jpegoptim optipng pngquant gifsicle 
RUN apt-get install -y vim 
RUN apt-get install -y libzip-dev 
RUN apt-get install -y unzip 
RUN apt-get install -y git 
RUN apt-get install -y libonig-dev 
RUN apt-get install -y curl

# Install extensions for php
RUN docker-php-ext-install pdo_mysql mbstring zip exif pcntl
RUN docker-php-ext-configure gd --with-freetype --with-jpeg
RUN docker-php-ext-install gd

# Install composer (php package manager)
RUN curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/local/bin 
filename=composer

# Copy existing application directory contents to the working directory
COPY . /var/www/

# Assign permissions of the working directory to the www-data user
# RUN chown -R www-data:www-data /var/www/*
RUN chown -R www-data:www-data /var/www//storage

# Expose port 9000 and start php-fpm server (for FastCGI Process Manager)
EXPOSE 9000
CMD ["php-fpm"]

Answer 1

我通过将DB_HOST=127.0.0.1更改为DB_HOST=host.docker.internal

就像这个问题