shinejh0528/mysql repository overview

docker run -itd -p 3306:3306 --name mysql shinejh0528/mysql:9.3.1

docker run -itd -p 3306:3306 -v /data/mysql_docker_test/:/data/mysql -v ~/script/docker/mysql/1.1.0/config:/data/config -e mycnf=/data/config/my.cnf -e root_password=root --name mysql shinejh0528/mysql:9.3.1

docker exec -it [container id] /bin/bash
service mysql start

cat /etc/mysql/my.cnf

mysqld --initialize-insecure --user=mysql

service mysql start
# change password
mysql -u root -e "ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; FLUSH PRIVILEGES;"

[mysqld]
#port=3307
datadir=/data/mysql
log-bin=/data/mysql/mysql-bin.log
server-id = 1
expire_logs_days = 10
max_binlog_size = 100M
log_bin_trust_function_creators = 1
collation-server = utf8mb4_general_ci
default-time-zone = "+09:00"
max_connections = 500
pid-file = /var/run/mysqld/mysqld.pid

[mysqldump]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4