docker安装mysql（含mysql各个版本）_docker mysql 版本

一、操作步骤

1.建立挂载所需目录

# 配置文件
mkdir -p /home/app/mysql/conf 
# 数据存储
mkdir -p /home/app/mysql/data
# 日志
mkdir -p /home/app/mysql/logs
1
2
3
4
5
6

2.新建配置文件

执行以下命令新建一个数据库的配置文件

vim /home/app/mysql/conf/my.cnf
1

将如下内容复制进去

# Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.

#

# This program is free software; you can redistribute it and/or modify

# it under the terms of the GNU General Public License as published by

# the Free Software Foundation; version 2 of the License.

#

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with this program; if not, write to the Free Software

# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA

#

# 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

secure-file-priv= NULL

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

symbolic-links=0

# Custom config should go here

!includedir /etc/mysql/conf.d/
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

3.run创建启动容器

# 下面是常用的msyql的三个版本
# mysql8.0.30 
docker run --restart=always -d -v /home/app/mysql/conf/my.cnf:/etc/my.cnf -v /home/app/mysql/logs:/logs -v /home/app/mysql/data/mysql:/var/lib/mysql -p 3306:3306 --name mysql8.0.30 -e MYSQL_ROOT_PASSWORD=super mysql:8.0.30
# mysql5.7.39 
docker run --restart=always -d -v /home/app/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /home/app/mysql/logs:/logs -v /home/app/mysql/data/mysql:/var/lib/mysql -p 3306:3306 --name mysql5.7.39 -e MYSQL_ROOT_PASSWORD=super mysql:5.7.39
# mysql:5.6.51
docker run --restart=always -d -v /home/app/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /home/app/mysql/logs:/logs -v /home/app/mysql/data/mysql:/var/lib/mysql -p 3306:3306 --name mysql5.6.51 -e MYSQL_ROOT_PASSWORD=super mysql:5.6.51
# mysql:5.5.61
docker run --restart=always -d -v /home/app/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /home/app/mysql/logs:/logs -v /home/app/mysql/data/mysql:/var/lib/mysql -p 3306:3306 --name mysql5.5.61 -e MYSQL_ROOT_PASSWORD=super mysql:5.5.61
1
2
3
4
5
6
7
8
9

以上参数解释

--restart=always -> 开机启动容器,容器异常自动重启

-d -> 以守护进程的方式启动容器

-v /home/app/mysql/conf.d/my.cnf:/etc/mysql/my.cnf -> 映射配置文件

-v /home/app/mysql/logs:/logs -> 映射日志

-v /home/app/mysql/data/mysql:/var/lib/mysql -> 映射数据

-p 3306:3306 -> 绑定宿主机端口

--name mysql8.0.30 -> 指定容器名称

-e MYSQL_ROOT_PASSWORD=super -> 初始化root密码
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

4.连接展示

5.参考连接

参考：参考信息1