OS/Linux

Orange Pi 3B : Docker - MySQL 설치

파란크리스마스 2024. 3. 8. 21:04
728x90

출처

리눅스 버전 확인

orangepi@orangepi3b:~$ uname -a
Linux orangepi3b 5.10.160-rockchip-rk356x #1.0.4 SMP Tue Dec 26 10:41:53 CST 2023 aarch64 aarch64 aarch64 GNU/Linux

도커 설치

orangepi@orangepi3b:~$ curl -sSL https://get.docker.com | sh
## Executing docker install script, commit: e5543d473431b782227f8908005543bb4389b8de
+ sudo -E sh -c apt-get update -qq >/dev/null
+ sudo -E sh -c DEBIAN_FRONTEND=noninteractive apt-get install -y -qq apt-transport-https ca-certificates curl >/dev/null
+ sudo -E sh -c install -m 0755 -d /etc/apt/keyrings
+ sudo -E sh -c curl -fsSL "https://download.docker.com/linux/ubuntu/gpg" | gpg --dearmor --yes -o /etc/apt/keyrings/docker.gpg
gpg: WARNING: unsafe ownership on homedir '/home/orangepi/.gnupg'
+ sudo -E sh -c chmod a+r /etc/apt/keyrings/docker.gpg
+ sudo -E sh -c echo "deb [arch=arm64 signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/ubuntu focal stable" > /etc/apt/sources.list.d/docker.list
+ sudo -E sh -c apt-get update -qq >/dev/null
+ sudo -E sh -c DEBIAN_FRONTEND=noninteractive apt-get install -y -qq docker-ce docker-ce-cli containerd.io docker-compose-plugin docker-ce-rootless-extras docker-buildx-plugin >/dev/null
+ sudo -E sh -c docker version
Client: Docker Engine - Community
 Version:           25.0.3
 API version:       1.44
 Go version:        go1.21.6
 Git commit:        4debf41
 Built:             Tue Feb  6 21:13:09 2024
 OS/Arch:           linux/arm64
 Context:           default
 
Server: Docker Engine - Community
 Engine:
  Version:          25.0.3
  API version:      1.44 (minimum version 1.24)
  Go version:       go1.21.6
  Git commit:       f417435
  Built:            Tue Feb  6 21:13:09 2024
  OS/Arch:          linux/arm64
  Experimental:     false
 containerd:
  Version:          1.6.28
  GitCommit:        ae07eda36dd25f8a1b98dfbf587313b99c0190bb
 runc:
  Version:          1.1.12
  GitCommit:        v1.1.12-0-g51d5e94
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0
 
================================================================================
 
To run Docker as a non-privileged user, consider setting up the
Docker daemon in rootless mode for your user:
 
    dockerd-rootless-setuptool.sh install
 
Visit https://docs.docker.com/go/rootless/ to learn about rootless mode.
 
 
To run the Docker daemon as a fully privileged service, but granting non-root
users access, refer to https://docs.docker.com/go/daemon-access/
 
WARNING: Access to the remote API on a privileged Docker daemon is equivalent
         to root access on the host. Refer to the 'Docker daemon attack surface'
         documentation for details: https://docs.docker.com/go/attack-surface/
 
================================================================================

도커 버전 확인

orangepi@orangepi3b:~$ sudo docker version
Client: Docker Engine - Community
 Version:           25.0.3
 API version:       1.44

도커 이미지 다운로드, 이미지 목록 조회, 이미지 삭제

arm64 플랫폼 옵션을 주지 않으면 아래와 같은 오류가 발생하므로 --platform linux/arm64 옵션 추가 필요

WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested

mysql 이미지 받아오기 (pull)

orangepi@orangepi3b:~$ docker pull --platform linux/arm64 arm64v8/mysql
Using default tag: latest
latest: Pulling from arm64v8/mysql
ea4e27ae0b4c: Already exists 
837904302482: Pull complete 
3c574b61b241: Pull complete 
654fc4f3eb2d: Pull complete 
32da9c2187e3: Pull complete 
dc99c3c88bd6: Pull complete 
970181cc0aa6: Pull complete 
d77b716c39d5: Pull complete 
9e650d7f9f83: Pull complete 
acc21ff36b4b: Pull complete 
Digest: sha256:ac1b9d1c2098dfcb70e5115fe81e7bfb77caf2e60c4d761a52b645d3d14c830b
Status: Downloaded newer image for arm64v8/mysql:latest
docker.io/arm64v8/mysql:latest

도커 이미지 조회

orangepi@orangepi3b:~$ docker images
REPOSITORY           TAG          IMAGE ID       CREATED         SIZE
oracle/db            19.19-EE     d8e82978a278   27 hours ago    5.89GB
oraclelinux          8-slim-19c   9c84640d1e78   27 hours ago    711MB
arm64v8/mysql        latest       e68e2614955c   7 weeks ago     638MB
mysql/mysql-server   5.7          a4ad24fe52cd   13 months ago   432MB

도커 이미지 삭제 (rmi)

orangepi@orangepi3b:~$ docker rmi a4ad24fe52cd
Untagged: mysql/mysql-server:5.7
Untagged: mysql/mysql-server@sha256:1178cdd375f758968cd834ac4057bae41307e64b7c69a9e145896e7b11f48064
Deleted: sha256:a4ad24fe52cdf82a35c6f2dae7670cfebf39357de983cb909db07c8b56df4dd1
Deleted: sha256:522d4bd955d841c9d9ee13768c45758adebc763f6ade609bf067567ec1f9db42
Deleted: sha256:0d4e56a725cdabce1459fceacb4ae726f01a3b74da88ae163828011a17695775
Deleted: sha256:3c0e6f8ea73046976b06eeb8643db4203d80e97582b772e033f539b79641b81b
Deleted: sha256:abde8b2762b759ea13f432207e38bd5af0b7f7a5a49e780e79499194ecbcfa39
Deleted: sha256:5836d1e6c9d144340d78e71f394fb81003df2e58146882e4ed1ea8eedf9a9e06
Deleted: sha256:5245f05f9eacc04eb63abf72ffba361c1834ffa6df119e7de7275be38f933673
Deleted: sha256:812f16602ebb1f9018247ecd71457fc2c9bb261ed03dde61daa8c204397fdbca
Deleted: sha256:62d9c4cbe8f4b26952ebb533b5336bf7af791db2b4288df65c9a685e1f2530cd

MySQL 도커 실행

MySQL 도커 처음 실행시 보안상 포트를 가지고 초기화 되지 않으므로, 포트없이 실행했다가 포트를 추가해야됨

오류 메시지 확인

orangepi@orangepi3b:~$ docker run --name mysql_container8 --net host -e MYSQL_RANDOM_ROOT_PASSWORD=passwd -d arm64v8/mysql:latest -p 3306:3306
ff7ac589ec49d0decfa3263a181db3866aa3da321386d05ca71ab8e08f648480
orangepi@orangepi3b:~$ docker logs -f mysql_container8
2024-03-09 09:45:27+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.
2024-03-09 09:45:27+00:00 [ERROR] [Entrypoint]: mysqld failed while attempting to check config
        command was: mysqld -p 3306:3306 --verbose --help --log-bin-index=/tmp/tmp.srui3XQiY0
        Enter password: mysqld: Can not perform keyring migration : Invalid --keyring-migration-source option.
2024-03-09T09:45:27.723601Z 0 [ERROR] [MY-011084] [Server] Keyring migration failed.
2024-03-09T09:45:27.727540Z 0 [ERROR] [MY-010119] [Server] Aborting

포트없이 MySQL 도커 실행

orangepi@orangepi3b:~$ docker run --name mysql_container --net host -e MYSQL_ROOT_PASSWORD=passwd -d arm64v8/mysql:latest
43d8707d88e70fb90400777e2a18bf270e59ca12a0f62725709811de366f793b

root 암호 변경

orangepi@orangepi3b:~$ docker exec -it mysql_container bash
bash-4.4# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
bash-4.4# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.3.0 MySQL Community Server - GPL
 
Copyright (c) 2000, 2024, 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.
 
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'sqldba';
Query OK, 0 rows affected (0.03 sec)
 
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
 
mysql> quit
Bye
bash-4.4# exit
exit
orangepi@orangepi3b:~$

MySQL 외부 접속 가능 하도록 포트 추가

도커 중지

orangepi@orangepi3b:~$ docker stop mysql_container
mysql_container

새로운 이미지(custom/mysql) 생성

orangepi@orangepi3b:~$ docker commit mysql_container custom/mysql
sha256:b5783eb91fbe61a7059352109b5ca5d76f57235cf76ea6aa210d90c7df7dd46b
orangepi@orangepi3b:~$ docker images
REPOSITORY         TAG          IMAGE ID       CREATED          SIZE
custom/mysql       latest       b5783eb91fbe   29 seconds ago   638MB
oracle/db          19.19-EE     d8e82978a278   28 hours ago     5.89GB
oraclelinux        8-slim-19c   9c84640d1e78   28 hours ago     711MB
arm64v8/mysql      latest       e68e2614955c   7 weeks ago      638MB

새로 생성된 이미지로 포트 개방(-p 옵션), 호스트 모드(--net host)로 실행

orangepi@orangepi3b:~$ docker run --name mysql_container3 --net host -p 3306:3306 -d custom/mysql
WARNING: Published ports are discarded when using host network mode
2e7d07a858cec931b2799a04fa0d87e13d781283b282e00cdfaae9b0011f6e39

포트 확인

orangepi@orangepi3b:~$ netstat -nao | grep  3306
tcp6       0      0 :::33060                :::*                    LISTEN      off (0.00/0/0)
tcp6       0      0 :::3306                 :::*                    LISTEN      off (0.00/0/0)

MySQL 외부 접속 계정 생성

orangepi@orangepi3b:~$ docker exec -it mysql_container3 bash
bash-4.4# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
bash-4.4# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.3.0 MySQL Community Server - GPL
 
Copyright (c) 2000, 2024, 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.
 
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> create user 'system'@'%' identified by 'manager';
Query OK, 0 rows affected (0.08 sec)
 
mysql> grant all privileges on *.* to 'system'@'%' with grant option; 
Query OK, 0 rows affected (0.03 sec)
 
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
 
mysql> quit
Bye
bash-4.4# exit
exit
orangepi@orangepi3b:~$

 

 

 

mysql_container 실행로그

orangepi@orangepi3b:~$ docker logs -f mysql_container
2024-03-09 09:49:38+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.
2024-03-09 09:49:39+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-03-09 09:49:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.
2024-03-09 09:49:40+00:00 [Note] [Entrypoint]: Initializing database files
2024-03-09T09:49:40.303194Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2024-03-09T09:49:40.310443Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.3.0) initializing of server in progress as process 83
2024-03-09T09:49:40.335938Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-09T09:49:41.660928Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-09T09:49:46.003354Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2024-03-09T09:49:54.792667Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
2024-03-09 09:49:54+00:00 [Note] [Entrypoint]: Database files initialized
2024-03-09 09:49:54+00:00 [Note] [Entrypoint]: Starting temporary server
2024-03-09T09:49:54.935137Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-03-09T09:49:55.360061Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.3.0) starting as process 127
2024-03-09T09:49:55.425848Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-09T09:49:55.866191Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-09T09:49:56.852795Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-09T09:49:56.852979Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-09T09:49:56.858101Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-03-09T09:49:56.964591Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-03-09T09:49:56.965191Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.3.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
2024-03-09 09:49:57+00:00 [Note] [Entrypoint]: Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
 
2024-03-09 09:50:12+00:00 [Note] [Entrypoint]: Stopping temporary server
2024-03-09T09:50:12.453181Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.3.0).
2024-03-09T09:50:14.164768Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.3.0)  MySQL Community Server - GPL.
2024-03-09T09:50:14.164882Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-03-09 09:50:14+00:00 [Note] [Entrypoint]: Temporary server stopped
 
2024-03-09 09:50:14+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
 
2024-03-09T09:50:14.518790Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-03-09T09:50:14.968538Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.3.0) starting as process 1
2024-03-09T09:50:14.999252Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-09T09:50:15.435084Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-09T09:50:16.292584Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-09T09:50:16.292755Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-09T09:50:16.297943Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-03-09T09:50:16.409360Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-03-09T09:50:16.410060Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.3.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2024-03-09T09:55:18.406055Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.3.0).
2024-03-09T09:55:19.636074Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.3.0)  MySQL Community Server - GPL.
2024-03-09T09:55:19.636203Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-03-09 09:55:37+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.
2024-03-09 09:55:37+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-03-09 09:55:37+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-03-09T09:55:38.852935Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-03-09T09:55:39.283175Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.3.0) starting as process 1
2024-03-09T09:55:39.314261Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-09T09:55:39.738652Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-09T09:55:40.511370Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-09T09:55:40.511549Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-09T09:55:40.516103Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-03-09T09:55:40.631638Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-03-09T09:55:40.632233Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.3.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2024-03-09T09:56:44.377487Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.3.0).
2024-03-09T09:56:45.800653Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.3.0)  MySQL Community Server - GPL.
2024-03-09T09:56:45.800765Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-03-09 10:00:38+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.
2024-03-09 10:00:39+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-03-09 10:00:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-03-09T10:00:40.385155Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-03-09T10:00:40.829162Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.3.0) starting as process 1
2024-03-09T10:00:40.860129Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-09T10:00:41.304886Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-09T10:00:42.032814Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-09T10:00:42.033052Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-09T10:00:42.037876Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-03-09T10:00:42.150425Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-03-09T10:00:42.151172Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.3.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2024-03-09T10:04:30.861529Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.3.0).
2024-03-09T10:04:32.161246Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.3.0)  MySQL Community Server - GPL.
2024-03-09T10:04:32.161362Z 0 [System] [MY-015016] [Server] MySQL Server - end.

mysql_container3 실행로그

orangepi@orangepi3b:~$ docker logs -f mysql_container3
2024-03-09 10:09:12+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.
2024-03-09 10:09:12+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-03-09 10:09:12+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.3.0-1.el8 started.
2024-03-09 10:09:13+00:00 [Note] [Entrypoint]: Initializing database files
2024-03-09T10:09:13.803123Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2024-03-09T10:09:13.810328Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.3.0) initializing of server in progress as process 81
2024-03-09T10:09:13.835939Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-09T10:09:15.144494Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-09T10:09:19.134540Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2024-03-09T10:09:28.248727Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
2024-03-09 10:09:28+00:00 [Note] [Entrypoint]: Database files initialized
2024-03-09 10:09:28+00:00 [Note] [Entrypoint]: Starting temporary server
2024-03-09T10:09:28.392803Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-03-09T10:09:28.834410Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.3.0) starting as process 125
2024-03-09T10:09:28.897229Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-09T10:09:29.337702Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-09T10:09:30.318440Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-09T10:09:30.318621Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-09T10:09:30.323639Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-03-09T10:09:30.429794Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-03-09T10:09:30.430597Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.3.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
2024-03-09 10:09:30+00:00 [Note] [Entrypoint]: Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
 
2024-03-09 10:09:45+00:00 [Note] [Entrypoint]: Stopping temporary server
2024-03-09T10:09:45.987307Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.3.0).
2024-03-09T10:09:47.650362Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.3.0)  MySQL Community Server - GPL.
2024-03-09T10:09:47.650472Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-03-09 10:09:47+00:00 [Note] [Entrypoint]: Temporary server stopped
 
2024-03-09 10:09:48+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
 
2024-03-09T10:09:48.052593Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-03-09T10:09:48.499846Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.3.0) starting as process 1
2024-03-09T10:09:48.530842Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-03-09T10:09:48.979003Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-03-09T10:09:49.756543Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-03-09T10:09:49.756714Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-03-09T10:09:49.761885Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-03-09T10:09:49.872098Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-03-09T10:09:49.872650Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.3.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
저작자표시