Docker error connecting to host mysql

Question

Docker version 17.03.1-ce, build c6d412e OS: Ubuntu

I am trying to connect to host mysql from the docker container. but i am getting this error.

Error: connect ECONNREFUSED 0.0.0.0:3306

I am getting same for mysql if i use mysql container. Tried 127.0.0.1 and localhost also.

version: '2'

services:

### Applications Code Container 
#############################

  applications:
    image: tianon/true
    volumes:
      - ${APPLICATION}:/var/www/html

  apache2:
    build:
      context: ./apache2
    volumes_from:
      - applications
    volumes:
      - ${APACHE_HOST_LOG_PATH}:/var/log/apache2
      - ./apache2/sites:/etc/apache2/sites-available
    ports:
      - "${APACHE_HOST_HTTP_PORT}:80"
      - "${APACHE_HOST_HTTPS_PORT}:443"
    networks:
      - frontend
      - backend

  node:
    build:
      context: ./node
    volumes_from:
      - applications
    ports:
      - "4000:30001"
    networks:
      - frontend
      - backend    


### MySQL Container  #########################################

  mysql:
    build:
      context: ./mysql
    environment:
      - MYSQL_DATABASE=${MYSQL_DATABASE}
      - MYSQL_USER=${MYSQL_USER}
      - MYSQL_PASSWORD=${MYSQL_PASSWORD}
      - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
    volumes_from:
      - applications  
    volumes:
      - ${DATA_SAVE_PATH}/mysql:/var/lib/mysql
      - ./mysql/docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d
    ports:
      - "${MYSQL_PORT}:3306"
    networks:
      - backend


### Networks Setup ############################################

networks:
  frontend:
    driver: "bridge"
  backend:
    driver: "bridge"

### Volumes Setup #############################################

volumes:
  mysql:
    driver: "local"
  mongo:
    driver: "local"
  node:
    driver: "local"
  apache2:
    driver: "local"

What port binding you see with docker-compose ps for mysql? — Robert
– Robert, Commented Jun 1, 2017 at 16:35
I am more concerned about connecting with docker host mysql, creating a mysql container was just a try. — Sandhu
– Sandhu, Commented Jun 1, 2017 at 16:38
Oh.. I understand. Use this: 172.17.0.1:3306. That IP is fixed for your host docker, visible from container. Give a try — Robert
– Robert, Commented Jun 1, 2017 at 16:40
Nope. not working. I am also connecting to the mongo db. Which is on another server. That is working. — Sandhu
– Sandhu, Commented Jun 1, 2017 at 16:44

benjah1 · Accepted Answer · 2017-06-01 15:49:23Z

0

Instead of using 0.0.0.0, 127.0.0.1 or localhost, you should use your host machine's IP. This is because each container is a individual node in the network.

Or if you can inspect your MySQL container, and get the IP of it, you can use the IP as well, since they are on the same network.

answered Jun 1, 2017 at 15:49

benjah1

1,5301 gold badge13 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

benjah1 Over a year ago

@Sandhu I see you are building the mysql. Can you provide the mysql log? docker-compose logs mysql. I suspect if the mysql is running, or bind to an ip.

Collectives™ on Stack Overflow

Docker error connecting to host mysql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related