MySQL in Docker draaien: simpele installatie stap voor stap

Docker installeren en MySQL-container starten

Docker op Ubuntu zetten? Check deze gids: Docker installeren op Ubuntu.

Start een MySQL-container op de achtergrond. Root-wachtwoord is test.

docker run --rm -it -e MYSQL_ROOT_PASSWORD=test -d mysql

• -d: draait 'm op de achtergrond en toont de container-ID.
• --rm: wist de container automatisch na stoppen.

Actieve containers bekijken

docker ps

CONTAINER ID      IMAGE    COMMAND                  CREATED         STATUS        PORTS                   NAMES
8ee2e6c8174d      mysql    "docker-entrypoint.s…"    9 sec ago       Up 7 sec      3306/tcp, 33060/tcp     condescending_snyder

MySQL-shell openen

docker exec -it 8ee2e6c8174d mysql -u root -ptest

mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.15 MySQL Community Server - GPL
mysql> 

Container-details checken

Bekijk netwerk, volumes en meer.

docker inspect 8ee2e6c8174d

[
    {
        "Id": "8ee2e6c8174d4138026f1d54addf9aadc7fbe22727c7f1fb9ca996ce5f7601b2",
        "Created": "2019-03-28T20:53:46.84185469Z",
        "State": {
            "Status": "running",
            "Running": true,
        },
        "Networks": {
            "bridge": {
                "Gateway": "172.17.0.1",
                "IPAddress": "172.17.0.2",
                "MacAddress": "02:42:ac:11:00:02"
            }
        }
    }
]

Verbinding maken via IP

mysql -u root -ptest -h 172.17.0.2

Alle containers tonen (ook gestopte)

docker ps -a

CONTAINER ID     IMAGE     COMMAND                  CREATED        STATUS                  PORTS                    NAMES
8ee2e6c8174d      mysql     "docker-entrypoint.s…"    2 min ago      Up 2 min                3306/tcp, 33060/tcp      condescending_snyder
913f33f5a848      mysql     "docker-entrypoint.s…"    12 min ago     Exited (0) 11 min ago                          jovial_dubinsky
b36cf8b3b664      mysql     "docker-entrypoint.s…"    22 min ago     Exited (1) 22 min ago                          cocky_mcnulty

Alle images weergeven

docker images

REPOSITORY    TAG      IMAGE ID       CREATED      SIZE
mysql         latest   7bb2586065cd   45 hours ago 477MB