Docker. Connect from one container to another container with mysql

I have a network:

docker network create -d bridge --subnet 172.25.0.0/16 container_network

I have one container with mysql running. Run command:

  • Can't access rexster interface via browser — connection refused
  • Viewing mounted docker container in browser
  • How to properly run Docker on Google Compute Engine (auto restart)
  • node.js in a dockerfile cant connect to mongolabs via mongoose: getaddrinfo ESRCH
  • inotifywait with Docker command and variable
  • Ignore directories with .dockerignore or volume?
  • docker run -tid -p 3306:3306 --name container_mysql --network container_network container_mysql
    

    And one container with code:

    docker run -tid -v $(pwd):/code -p 5000:5000 --name container_code --network container_network container_code
    

    I am trying to access mysql DB from my container with code, but nothing works:

    mysql -h 172.17.0.1 -P 3306 -u root -p
    mysql -h container_mysql -P 3306 -u root -p
    mysql -h 127.0.0.1 -P 3306 -u root -p
    mysql -h 0.0.0.0 -P 3306 -u root -p
    

    First command gives me:

    ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
    

    Others:

    ERROR 2003 (HY000): Can't connect to MySQL server on <host> (111)
    

    Any ideas how to achieve the goal?

    Edit 1
    Dockerfile for Mysql container:

    FROM ubuntu:16.04
    RUN apt-get update
    RUN echo "mysql-server mysql-server/root_password password 1234" | debconf-set-selections
    RUN echo "mysql-server mysql-server/root_password_again password 1234" | debconf-set-selections
    RUN apt-get install mysql-server -y
    

  • Java + Github + Docker
  • Missing tag after docker stack deploy
  • Can't push to remote docker registry
  • Can't connect to mongodb instance running on docker-machine
  • docker-compose and graceful Celery shutdown
  • Cannot start docker daemon in CentOS7
  • One Solution collect form web for “Docker. Connect from one container to another container with mysql”

    First of all, you should consider to use networks insted of link. First, link should be deprecated very soon. Second, when you put 2 container on the same network, docker add to the /etc/hosts of both containers a line for resolve the IP from container name. This is for allows you to access to a container with their name. In your case you can access to the mysql container from code container like this

    mysql -h container_mysql

    Look this link for more details about docker networking. This link for more info about docker-compose and networking.

    Docker will be the best open platform for developers and sysadmins to build, ship, and run distributed applications.