Docker mysql 시간 변경, vi command not found, docker 서버 시간 변경

SELECT NOW(), @@system_time_zone;
-- [현재시간 -9시간],UTC

1. docker mysql 컨테이너아이디 조회
$docker ps -a
CONTAINER_ID   IMAGE
[CONTAINER_ID]   mysql

2. docker mysql 접속
$ sudo docker exec -it [CONTAINER_ID] /bin/bash
bash-4.4# vi /etc/my.cnf
[mysqld]
default_time_zone = '+09:00'

[mysqld]
# 아래 추가
default_time_zone = '+09:00'

3. docker mysql 재기동
$ sudo docker stop [CONTAINER_ID]
$ sudo docker start [CONTAINER_ID]

4. mysql 시간확인
정상!!!!

TIP. vi : command not found 

bash-4.4# vi /etc/my.cnf
vi: command not found
bash-4.4# apt-get update
bash: apt-get: command not found
bash-4.4# yum install -y vim
bash: yum: command not found
bash-4.4# microdnf install -y vim
Downloading metadata...

Downloading metadata...
Package                                                                                                       Repository                                 Size
Installing:
 glibc-gconv-extra-2.28-211.0.1.el8.x86_64                                                                    ol8_baseos_latest                        1.6 MB
 gpm-libs-1.20.7-17.el8.x86_64                                                                                ol8_appstream                           39.9 kB
 vim-common-2:8.0.1763-19.0.1.el8_6.4.x86_64                                                                  ol8_appstream                            6.6 MB
 vim-enhanced-2:8.0.1763-19.0.1.el8_6.4.x86_64                                                                ol8_appstream                            1.4 MB
 vim-filesystem-2:8.0.1763-19.0.1.el8_6.4.noarch                                                              ol8_appstream                           51.8 kB
 which-2.21-18.el8.x86_64                                                                                     ol8_baseos_latest                       50.6 kB
Transaction Summary:
 Installing:        6 packages
 Reinstalling:      0 packages
 Upgrading:         0 packages
 Obsoleting:        0 packages
 Removing:          0 packages
 Downgrading:       0 packages
Downloading packages...
Running transaction test...
Installing: vim-filesystem;2:8.0.1763-19.0.1.el8_6.4;noarch;ol8_appstream
Installing: gpm-libs;1.20.7-17.el8;x86_64;ol8_appstream
Installing: which;2.21-18.el8;x86_64;ol8_baseos_latest
Installing: glibc-gconv-extra;2.28-211.0.1.el8;x86_64;ol8_baseos_latest
Installing: vim-common;2:8.0.1763-19.0.1.el8_6.4;x86_64;ol8_appstream
Installing: vim-enhanced;2:8.0.1763-19.0.1.el8_6.4;x86_64;ol8_appstream
Complete.

(vim 명령어로 파일 수정 가능!)
bash-4.4# vim /etc/my.cnf

Tip. vi 설치하기 싫을 경우

file_name 내용에 text 글씨 추가

bash-4.4# echo "text" >> [file_name]
bash-4.4# cat [file_name]
.......[file_name] 내용.....
text

file_name 내용을 text로 덮어쓰기

bash-4.4# echo "text" > [file_name]
bash-4.4# cat [file_name]
text

docker 서버 시간 변경 방법

bash-4.4#  date
Thu Feb 23 06:49:55 UTC 2023
bash-4.4# ls -l /etc/localtime
-rw-r--r-- 1 root root 127 Nov  3 13:53 /etc/localtime
bash-4.4# rm -rf /etc/localtime
bash-4.4# ln -s /usr/share/zoneinfo/Asia/Seoul /etc/localtime
(docker mysql 재기동)
[DB 접속 에러]
The server time zone value 'KST' is unrecognized or represents more than one time zone
연동 방법을 변경 하면 되나, 다른 사람들에게 공유 해야하니깐... 
가장 빠른 해결..
(docker mysql 시간 되돌림)
bash-4.4# rm -rf /etc/localtime
bash-4.4# ln -s /usr/share/zoneinfo/Etc/UTC /etc/localtime
(docker mysql 재기동)