Docker部署MySQL8

1. 创建目录

• /data/mysql/conf
• /data/mysql/data

2. 在conf里创建配置文件mysql.cnf
   参数可根据实际情况调整

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL
transaction_isolation=READ-COMMITTED
innodb_log_file_size=256M
max_allowed_packet=34M

3. 启动容器

docker run -v /data/test/mysql/conf:/etc/mysql/conf.d \
 -v /data/test/mysql/data:/var/lib/mysql \
 -e MYSQL_ROOT_PASSWORD=admin \
 -p 3307:3306 --rm \
 --name mysql2 \
 mysql:8.0 --character-set-server=utf8mb4 --collation-server=utf8mb4_bin