Sådan installerer du MySQL i en Docker-container

Installer Docker

Først skal du have Docker på plads. Tjek denne guide til Ubuntu: Sådan installerer du Docker på Ubuntu.

Start en MySQL-container i baggrunden. Root-adgangskoden er "test".

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

• -d: Kører i baggrunden og viser container-ID.
• --rm: Sletter containeren automatisk ved stop.

Se aktive containere

docker ps

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

Gå ind i MySQL-shellen

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>

Tjek container-detaljer

Her ser du netværk, volumes og mere.

docker inspect 8ee2e6c8174d

[
    {
        "Id": "8ee2e6c8174d4138026f1d54addf9aadc7fbe22727c7f1fb9ca996ce5f7601b2",
        "Created": "2019-03-28T20:53:46.84185469Z",
        "Path": "docker-entrypoint.sh",
        "State": {
            "Status": "running",
            "Running": true,
            ...
        },
        "Networks": {
            "bridge": {
                "IPAddress": "172.17.0.2",
                ...
            }
        }
    }
]

Forbind til MySQL via IP

mysql -u root -ptest -h 172.17.0.2

Vis alle containere (kørende og stoppede)

docker ps -a

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

Vis alle images

docker images

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