mysql 공부 환경 with container

1. Install podman

podman은 docker와 같은 컨테이너 플랫폼.


# MAC OS
brew install podman

# After installed
podman machine init
podman machine start

2. Run mysql container


# 1. Search mysql image
podman search mysql --filter=is-official

# 2. pull mysql image
podman pull docker.io/library/mysql

# 3. Show downloaded image
podman images

# REPOSITORY               TAG         IMAGE ID      CREATED       SIZE
# docker.io/library/mysql  latest      1732fe3340d5  28 hours ago  602 MB

# 4. Start mysql container
podman run --name sql-tutorial -e MYSQL_ROOT_PASSWORD=0000 -d docker.io/library/mysql

# 5. Show running container
podman ps

# CONTAINER ID  IMAGE                           COMMAND     CREATED        STATUS        PORTS       NAMES
# 1d0d518d3828  docker.io/library/mysql:latest  mysqld      3 seconds ago  Up 3 seconds              sql-tutorial

3. Create mysql session

# 1. mysql 컨테이너 터미널에 mysql 커맨드를 실행
podman exec -it sql-tutorial mysql -u root -p

# Enter password:
# Welcome to the MySQL monitor.  Commands end with ; or \g.
# Your MySQL connection id is 8
# Server version: 8.0.33 MySQL Community Server - GPL

# Copyright (c) 2000, 2023, Oracle and/or its affiliates.

# Oracle is a registered trademark of Oracle Corporation and/or its
# affiliates. Other names may be trademarks of their respective
# owners.

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

# 2. Show databases

mysql> SHOW DATABASES;

# +--------------------+
# | Database           |
# +--------------------+
# | information_schema |
# | mysql              |
# | performance_schema |
# | sys                |
# +--------------------+
# 4 rows in set (0.02 sec)

4. Populating the databse

Example database 에 들어가서 예제 DB를 다운받는다.
예제 파일(.sql)을 mysql container로 옮긴다

podman cp ./sakila-db sql-tutorial:/tmp/

정상적으로 들어갔는지 shell을 통해 확인한다.


podman exec -it sql-tutorial bash

# bash-4.4# ls
# bin  boot  dev	docker-entrypoint-initdb.d  entrypoint.sh  etc	home  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  tmp  usr  var
# bash-4.4# cd tmp
# bash-4.4# ls
# sakila-db
# bash-4.4# eixt

mysql cli session을 통해서 .sql을 source 해준다.

podman exec -it sql-tutorial mysql -u root -p

#  ...

mysql> source /tmp/sakila-db/sakila-schema.sql
mysql> source /tmp/sakila-db/sakila-data.sql

데이터베이스 리스트를 확인한다.

mysql> SHOW DATABASES;
# +--------------------+
# | Database           |
# +--------------------+
# | information_schema |
# | mysql              |
# | performance_schema |
# | sakila             |
# | sys                |
# +--------------------+
# 5 rows in set (0.00 sec)

Reference

podman