Home / Questions / 158532
Accepted
dddenis
Asked: 2020-04-24 12:53:42 +0800 CST 2020-04-24 12:53:42 +0800 CST

How to give visibility of my MySQL container to my Node container?

  • 772

I am trying to connect to the database with my other container and it always throws me connect ECONNREFUSED 127.0.0.1:3306.

I don't understand where the visibility problem between containers is.

docker file

FROM node:latest
RUN useradd --user-group --create-home --shell /bin/false app
ENV HOME=/home/app
COPY package.json $HOME/my_project/
RUN chown -R app:app $HOME/*
USER app 
WORKDIR $HOME/my_project
RUN npm install --silent --progress=false
USER root
COPY . $HOME/my_project
RUN chown -R app:app $HOME/*
USER app

docker-compose.yml

version: '3'
networks:
    my_network:
        driver: bridge
services:
    database:
        container_name: my_mysql
        image: mysql
        environment:
            MYSQL_ROOT_PASSWORD: root
            MYSQL_DATABASE: www_test
            MYSQL_USER: root
            MYSQL_PASSWORD: root
        ports:
            - '3306:3306'
        volumes:
            - '~/docker-volumes/test/mysql:/var/lib/mysql'
        restart: always
        networks:
            - my_network
    app:
        container_name: my_app
        build: .
        command: 'npm run serve'
        ports:
            - '3000:3000'
        depends_on:
            - database
        volumes:
            - '.:/home/app/my_project'
            - /home/app/my_project/node_modules
        restart: always
        networks:
            - my_network
docker

1 Answers

  1. Best Answer

    I have already found the solution, not indicating the driver and exposing the ports of both services.

    .env

    NODE_ENV=development

APP_PORT=3000
DB_PORT=3306

MYSQL_ROOT_PASSWORD=root
MYSQL_USER=root
MYSQL_PASSWORD=root
MYSQL_DATABASE=my_db

    docker file

    FROM node:alpine
WORKDIR /usr/app
COPY package.json yarn.lock ./
RUN yarn --pure-lockfile
COPY . .

    docker-compose.yml

    version: '3.3'
services:
  node:
    build: .
    command: 'npm run serve'
    env_file:
        - .env
    ports: 
        - '${APP_PORT}:${APP_PORT}'
    volumes:
        - .:/usr/app/
        - /usr/app/node_modules
  mysql:
    image: mysql:5.7
    volumes: 
        - ~/DockerVolumes/my_project/mysql:/var/lib/mysql
    env_file:
        - .env
    command: 'mysqld'
    ports: 
        - '${DB_PORT}:${DB_PORT}'

    commands

    docker-compose down
docker-compose up --build -d
    • 2