Docker部署MySQL5.7

Docker部署MySQL5.7

1.拉取mysql5.7 镜像

docker pull mysql:5.7

2.检查镜像是否下载完毕

 docker images

如果如下图显示就说明下载成功

准备数据目录

mkdir -p /opt/docker/mysql5.7/conf
mkdir -p /opt/docker/mysql5.7/logs
mkdir -p /opt/docker/mysql5.7/data

创建配置文件

cd /opt/docker/mysql5.7/conf

vi my.cnf

# The MySQL  Server configuration file.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysqld]
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
datadir		= /var/lib/mysql
log-error	= /var/log/mysql/error.log
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0


max_connections = 2000
max_user_connections = 1900
max_connect_errors = 100000
max_allowed_packet = 50M
lower_case_table_names=1
[mysqld]
skip-name-resolve
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

启动容器

docker run  -p 3307:3306 --name mysql5.7-3307 \
-v /opt/docker/mysql5.7/conf/my.cnf:/etc/mysql/my.cnf \
-v /opt/docker/mysql5.7/logs:/logs \
-v /opt/docker/mysql5.7/mysql:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7 \
--character_set_server=utf8

配置远程访问

docker exec -it mysql5.7-3307 bash
mysql -uroot -P 123456
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;