[Docker] Run Mysql Server container and setup

# Make Data folders for mysql volumn

mkdir /data

# Run mysql container

docker run \

-p 3306:3306 \

--name mysql_server \

-v /data:/var/lib/mysql \

-e MYSQL_ROOT_PASSWORD={{SERVER ROOT}} \

-e MYSQL_USER={{USER_ID}} \

-e MYSQL_PASSWORD={{USER_PASSWORD}}} \

-e TZ='{{TIMEZONE}}' \

-d mysql:8.0.13

# Got error with message "MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client"

ALTER USER '{{ID}}'@'{{HOST}}' IDENTIFIED WITH mysql_native_password BY '{{PASSWORD}}'

# Example

docker run -it \

-p 3306:3306 \

--name mysql \

-v /data:/var/lib/mysql \

-e TZ='Asia/Seoul' \

-e MYSQL_ROOT_PASSWORD='dbpassword' \

-e MYSQL_USER='dbuser' \

-e MYSQL_PASSWORD='dbpassword' \

-e MYSQL_DATABASE='firstdb' \

-d mysql