docker 启动mysql

创建配置文件

mysqld.cnf

[mysqld]
pid-file      = /var/run/mysqld/mysqld.pid
socket        = /var/run/mysqld/mysqld.sock
datadir       = /var/lib/mysql
log-error     = /var/lib/mysql/error.log
tls_version   = 'TLSv1.2'
sql_mode      = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER
symbolic-links        = 0
default-time-zone     = '+8:00'
log_timestamps        = system
character-set-server  = utf8mb4 
collation-server      = utf8mb4_unicode_ci
log-bin               = mysql-bin
binlog_format         = ROW
max_binlog_size       = 100M
expire_logs_days      = 0 
server_id             = 11
explicit_defaults_for_timestamp = true

启动

#!/bin/bash
docker run --name mysqld --restart=always \
-v /etc/localtime:/etc/localtime:ro \
-v /opt/mysqld/conf:/etc/mysql/mysql.conf.d \
-v /opt/mysqld/data:/var/lib/mysql \
-p 0.0.0.0:33810:3306/tcp \
-e MYSQL_ROOT_PASSWORD=my-secret-pw \
-d mysql:5.7.44