docker 安装部署 mysql（配置文件启动）

获取 mysql 镜像

docker pull mysql:5.6
docker images

 

创建容器

创建宿主机 redis 容器的数据和配置文件目录

# 创建宿主机 redis 容器的数据和配置文件目录
mkdir /data/docker/mysql_3306/{conf,data} -p
cd /data/docker/mysql_3306

 

获取 mysql 的默认配置模版

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

 

character-set-server=utf8

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

 

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Recommended in standard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION

 

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

 

[mysql]

default-character-set=utf8

 

[client]

default-character-set=utf8

创建容器

# 创建并运行一个名为 mysql_3306 的容器
docker run \
-p 3306:3306 \
-v $PWD/data:/var/lib/mysql \
-v $PWD/conf/my.cnf:/etc/mysql/my.cnf \
-e MYSQL_ROOT_PASSWORD=EMz@0SfvQ6H8p4cZ1 \
--name mysql_3306 \
-d mysql:5.6

查看容器

# 查看活跃的容器
docker ps

# 如果没有 mysql_3306 说明启动失败 查看错误日志
docker logs mysql_3306

# 查看 mysql_3306 的 ip 挂载 端口映射等信息
docker inspect myredis

# 查看 myredis 的端口映射
docker port mysql_3306