docker 사용해서 mariadb 설치하고 접속하기

도커 버전 출력

C:\Users\user>docker -v
Docker version 24.0.7, build afdd53b

 

도커 이미지 다운로드 

docker pull mariadb

 

도커 이미지 다운로드 (특정버전)

docker pull mariadb:10.5

 

도커 이미지 확인 

C:\Users\user>docker images
REPOSITORY   TAG         IMAGE ID       CREATED        SIZE
mariadb      latest      299933e6115e   3 days ago     405MB
mysql        latest      a88c3e85e887   3 weeks ago    632MB
mariadb      lts-jammy   6e74e5a7ddb3   3 months ago   404MB

 

도커 컨테이너 리스트 출력 

C:\Users\user>docker ps
CONTAINER ID   IMAGE     COMMAND                   CREATED          STATUS          PORTS                    NAMES
5aafa40968f9   mariadb   "docker-entrypoint.s…"   18 minutes ago   Up 17 minutes   0.0.0.0:3306->3306/tcp   mariadb-container

 

mariadb 컨테이너 생성및 실행 

C:\Users\user>docker run --name mariadb-container -e MYSQL_ROOT_PASSWORD=1234 -p 3306:3306 -d mariadb
Unable to find image 'mariadb:latest' locally
latest: Pulling from library/mariadb
57c139bbda7e: Pull complete
8e719691e27e: Pull complete
ccc5a36ed8aa: Pull complete
b152e08c924a: Pull complete
7957589f3980: Pull complete
2c8161bee37b: Pull complete
be008f8e31b5: Pull complete
4772ee009329: Pull complete
Digest: sha256:65c0c44bc4754bd03dc17396328f2adae8f156ebe6ec1edb928386886654785e
Status: Downloaded newer image for mariadb:latest
5aafa40968f9b4bc9c855c6d934b532a198f2b1a7a21036c28123ed8f0ff900c

 

mariadb 서버에 접속

C:\Users\user>docker exec -it mariadb-container mariadb -uroot -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 11.2.3-MariaDB-1:11.2.3+maria~ubu2204 mariadb.org binary distribution

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

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.001 sec)

MariaDB [(none)]>

 

docker 컨테이너 시작/중지/재시작 

# Docker 컨테이너 중지
$ docker stop mariadb-container

# Docker 컨테이너 시작
$ docker start mariadb-container

# Docker 컨테이너 재시작
$ docker restart mariadb-container