docker安装mysql5.7

1、拉取官方mysql5.7镜像

docker pull mysql:5.7

2、查看镜像库

3、创建mysql容器

(1)在本地创建mysql的映射目录

mkdir -p /home/mysql/data /home/mysql/logs /home/mysql/conf

(2)在 /home/mysql/conf中创建 mysqld.cnf 文件

[mysqld]
port=3306
pid-file    = /var/run/mysqld/mysqld.pid
socket        = /var/run/mysqld/mysqld.sock
datadir        = /var/lib/mysql
#log-error    = /var/log/mysql/error.log
# By default we only accept connections from localhost
bind-address    = 0.0.0.0
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server=utf8
default-time-zone=+08:00
lower_case_table_names=1
event_scheduler=ON
max_connections=10000
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_date,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

（3）创建容器,将数据,日志,配置文件映射到本机

docker run -p 3306:3306 --name mysql -v /home/mysql/mysql/conf:/etc/mysql/conf.d -v /home/mysql/mysql/logs:/logs -v /home/mysql/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=admin@123 -d mysql:5.7

4、启动mysql容器

docker start mysql

5、使用navicat工具测试链接