docker部署mysql5.7

docker部署mysql5.7

1. 拉去镜像
   docker pull mysql:5.7

2. 检查镜像
   docker images

3. 创建配置文件挂载目录
   mkdir -p /docker/mysql/conf
   mkdir -p /docker/mysql/logs
   mkdir -p /docker/mysql/mysql

4. 创建配置文件
   在 /docker/mysql/conf/ 创建配置文件my.cnf

5. 启动容器
   docker run -p 3306:3306 --name mysql
   -v /docker/mysql/conf/my.cnf:/etc/mysql/my.cnf
   -v /docker/mysql/logs:/logs
   -v /docker/mysql/mysql:/var/lib/mysql
   -e MYSQL_ROOT_PASSWORD=123456
   -d mysql:5.7

6. 检查容器信息
   docker ps 启动正常,就可以直接测试

7. my.cnf

[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

8. 如果远程链接不上还需要进行远程登录权限管理