To list Docker networks

docker network ls


NETWORK ID          NAME                DRIVER              SCOPE
58fa29cd9897        bridge              bridge              local               
e6f07fb628ff        devvhosts_default   bridge              local               
1b20cf0e2660        host                host                local               
e24d89089238        none                null                local  

There are 3 pre-defined networks and cannot be removed:

  • bridge
  • host
  • none

To remove unused docker networks:

docker network rm $(docker network ls -q).

So the current running container would be devvhosts_default.

Which docker container runs my database:

docker ps


CONTAINER ID        IMAGE                   COMMAND                  CREATED             STATUS              PORTS                           NAMES
8b30b55fb76b        nginx:alpine            "nginx -g 'daemon off"   About an hour ago   Up 56 minutes       443/tcp,>80/tcp   devvhosts_nginx_1
c55d7a0d1ba7        php:5.6.23-fpm-alpine   "php-fpm"                About an hour ago   Up 56 minutes       9000/tcp                        devvhosts_fpm5-6-23_1
7a398b243667        php:7.0.8-fpm-alpine    "php-fpm"                About an hour ago   Up 57 minutes       9000/tcp                        devvhosts_fpm7-0-8_1
949e358c6309        phpmyadmin/phpmyadmin   "/"                About an hour ago   Up 57 minutes>80/tcp            devvhosts_dbadmin_1
29f4cad29bc0        harianto/mysql          "mysqld --skip-grant-"   About an hour ago   Up 57 minutes       3306/tcp                        devvhosts_db_1

So it's devvhosts_db_1.

So my network would be --net devvhosts_default and the link as db would be: --link devvhosts_db_1:db.

I'll be using Alpine OS to run commands

docker run --rm --net devvhosts_default --link devvhosts_db_1:db -it alpine:latest /bin/sh

Now I'm in the Alpine shell. Since there is no mysql client installed we can do by following command:

# install mysql-client
apk add --update mysql-client

# open mysql shell and connect to host 'db'
mysql -h db
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 38
Server version: 10.1.14-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
| Database           |
| information_schema |
| stuff              |
2 rows in set (0.02 sec)

MariaDB [(none)]> \q