文档课题：docker下部署mysql 5.6.51
系统：rhel 7.3 64位
1、删旧镜像
[root@Leo-Docker ~]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
[root@Leo-Docker ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
b24358c2ff28 hello-world "/hello" 10 minutes ago Exited (0) 10 minutes ago wizardly_bhaskara
[root@Leo-Docker ~]# docker rm -f b24358c2ff28
b24358c2ff28
[root@Leo-Docker ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
[root@Leo-Docker ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
hello-world latest 9c7a54a9a43c 3 months ago 13.3kB
[root@Leo-Docker ~]# docker rmi 9c7a54a9a43c
Untagged: hello-world:latest
Untagged: hello-world@sha256:dcba6daec718f547568c562956fa47e1b03673dd010fe6ee58ca806767031d1c
Deleted: sha256:9c7a54a9a43cca047013b82af109fe963fde787f63f9e016fdc3384500c2823d
Deleted: sha256:01bb4fce3eb1b56b05adf99504dafd31907a5aadac736e36b27595c8b92f07f1
[root@Leo-Docker ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
2、安装mysql
--搜索镜像
[root@Leo-Docker ~]# docker search mysql
NAME DESCRIPTION STARS OFFICIAL AUTOMATED
mysql MySQL is a widely used, open-source relation… 14381 [OK]
mariadb MariaDB Server is a high performing open sou… 5490 [OK]
percona Percona Server is a fork of the MySQL relati… 620 [OK]
phpmyadmin phpMyAdmin - A web interface for MySQL and M… 848 [OK]
bitnami/mysql Bitnami MySQL Docker Image 93 [OK]
circleci/mysql MySQL is a widely used, open-source relation… 29
bitnami/mysqld-exporter 5
ubuntu/mysql MySQL open source fast, stable, multi-thread… 51
cimg/mysql 0
rapidfort/mysql RapidFort optimized, hardened image for MySQL 23
rapidfort/mysql8-ib RapidFort optimized, hardened image for MySQ… 9
google/mysql MySQL server for Google Compute Engine 23 [OK]
hashicorp/mysql-portworx-demo 0
rapidfort/mysql-official RapidFort optimized, hardened image for MySQ… 9
newrelic/mysql-plugin New Relic Plugin for monitoring MySQL databa… 1 [OK]
elestio/mysql elestio mysql Docker Image 0
databack/mysql-backup Back up mysql databases to... anywhere! 89
bitnamicharts/mysql 0
linuxserver/mysql A Mysql container, brought to you by LinuxSe… 39
mirantis/mysql 0
docksal/mysql MySQL service images for Docksal - https://d… 0
linuxserver/mysql-workbench 50
vitess/mysqlctld vitess/mysqlctld 1 [OK]
eclipse/mysql Mysql 5.7, curl, rsync 0 [OK]
drupalci/mysql-5.5 https://www.drupal.org/project/drupalci 3 [OK]
--拉取镜像
[root@Leo-Docker ~]# docker pull mysql:5.6
5.6: Pulling from library/mysql
35b2232c987e: Pull complete
fc55c00e48f2: Pull complete
0030405130e3: Pull complete
e1fef7f6a8d1: Pull complete
1c76272398bb: Pull complete
f57e698171b6: Pull complete
f5b825b269c0: Pull complete
dcb0af686073: Pull complete
27bbfeb886d1: Pull complete
6f70cc868145: Pull complete
1f6637f4600d: Pull complete
Digest: sha256:20575ecebe6216036d25dab5903808211f1e9ba63dc7825ac20cb975e34cfcae
Status: Downloaded newer image for mysql:5.6
docker.io/library/mysql:5.6
--查看images
[root@Leo-Docker ~]# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
mysql 5.6 dd3b2a5dcb48 20 months ago 303MB
3、创建容器
说明：
1)、容器内网络服务和外部机器不能直接通信;
2)、外部机器和宿主机可以直接通信;
3)、宿主机和容器可以直接通信;
4)、当容器中的网络服务需要被外部机器访问时，可将容器中提供服务的端口映射到宿主机的端口，外部机器访问宿主机的端口，从而间接访问容器的服务，此操作称为端口映射。
注意事项：
1)、需进行端口映射;
2)、需在宿主机的防火墙上开启对外访问端口;
3)、连接时需宿主机的IP地址.
--在/root下创建mysql目录用于存储mysql数据信息
[root@Leo-Docker ~]# mkdir /root/mysql
[root@Leo-Docker ~]# cd mysql
--在/root/mysql目录下创建容器.
# docker run -id \ #镜像启动一个容器，-id表示交互式运行
-p 3307:3306 \ #3307对外开放的端口号，3306为容器的端口，此步为端口映射，此处最好是3306:3306，3307以示区别
--name=mysql01 \ #给该容器取名mysql01
-v $PWD/conf:/etc/mysql/conf.d \ #'-v'表示数据点挂载，'$PWD'为当前目录，容器内部会创建/etc/mysql/conf.d存放配置文件
-v $PWD/logs:/logs \ #存放日志文件的路径
-v $PWD/data:/var/lib/mysql \ #存放数据文件的路径
-e MYSQL_ROOT_PASSWORD=123456 \ #mysql对外开放的root密码
mysql:5.6 #启动的镜像的名称
6c90d595cfeb0e1166f55735c409ad227475b8665e946e2eee6351f5b0030bc1
参数说明：
-i #启动交互式容器
-d #后台运行
-p #端口映射
-v #卷挂载
-e #环境配置
--name #容器名字
4、相关查询
4.1、文件查询
[root@Leo-Docker mysql]# ll
total 0
drwxr-xr-x. 2 root root 6 Aug 13 23:40 conf
drwxr-xr-x. 5 polkitd root 129 Aug 13 23:54 data
drwxr-xr-x. 2 root root 6 Aug 13 23:40 logs
[root@Leo-Docker mysql]# pwd
/root/mysql
[root@Leo-Docker mysql]# ll data
total 110604
-rw-rw----. 1 polkitd input 56 Aug 13 23:40 auto.cnf
drwx------. 2 polkitd input 54 Aug 14 00:09 booksDB
-rw-rw----. 1 polkitd input 12582912 Aug 14 00:09 ibdata1
-rw-rw----. 1 polkitd input 50331648 Aug 14 00:09 ib_logfile0
-rw-rw----. 1 polkitd input 50331648 Aug 13 23:40 ib_logfile1
drwx------. 2 polkitd input 4096 Aug 13 23:40 mysql
drwx------. 2 polkitd input 4096 Aug 13 23:40 performance_schema
[root@Leo-Docker mysql]# cd /
[root@Leo-Docker /]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
6c90d595cfeb mysql:5.6 "docker-entrypoint.s…" 20 seconds ago Up 19 seconds 0.0.0.0:3307->3306/tcp, :::3307->3306/tcp mysql01
--进入docker查询文件
[root@Leo-Docker ~]# docker exec -it mysql01 /bin/bash
root@6c90d595cfeb:/etc/mysql# pwd
/etc/mysql
root@6c90d595cfeb:/etc/mysql# ls -ltr
total 8
-rw-r--r--. 1 root root 839 Jul 9 2016 my.cnf.fallback
-rw-r--r--. 1 root root 1497 Jan 5 2021 mysql.cnf
lrwxrwxrwx. 1 root root 24 Dec 21 2021 my.cnf -> /etc/alternatives/my.cnf
drwxr-xr-x. 2 root root 24 Dec 21 2021 mysql.conf.d
drwxr-xr-x. 2 root root 6 Aug 13 15:40 conf.d
root@6c90d595cfeb:/# ls -ltr logs
total 0
root@6c90d595cfeb:/# ls -ltr /var/lib/mysql
total 110604
-rw-rw----. 1 mysql mysql 50331648 Aug 13 15:40 ib_logfile1
drwx------. 2 mysql mysql 4096 Aug 13 15:40 performance_schema
-rw-rw----. 1 mysql mysql 56 Aug 13 15:40 auto.cnf
drwx------. 2 mysql mysql 4096 Aug 13 15:40 mysql
drwx------. 2 mysql mysql 54 Aug 13 16:09 booksDB
-rw-rw----. 1 mysql mysql 12582912 Aug 17 15:35 ibdata1
-rw-rw----. 1 mysql mysql 50331648 Aug 17 15:35 ib_logfile0
4.2、数据库验证
--进入mysql容器
[root@Leo-Docker /]# docker exec -it mysql01 /bin/bash
--登录mysql
root@6c90d595cfeb:/# mysql -uroot -p123456
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.51 MySQL Community Server (GPL)
Copyright (c) 2000, 2021, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.01 sec)
mysql> create database booksDB;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| booksDB |
| mysql |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)
mysql> use booksDB;
Database changed
5、客户端连接
5.1、开启端口
使用外部mysql客户端操作mysql server，连接时需注意端口要和映射的端口保持一致。
注意：第一次配置完，若外部无法访问mysql server，重启docker、mysql容器即可。
开启端口
[root@Leo-Docker mysql]# firewall-cmd --zone=public --add-port=3307/tcp --permanent
success
[root@Leo-Docker mysql]# firewall-cmd --reload
success
5.2、连接测试
--客户端连接测试
[root@leo-mysql5721 ~]# ip a | grep 96
inet 192.168.133.96/24 brd 192.168.133.255 scope global ens33
[root@leo-mysql5721 ~]# mysql -uroot -p123456 -h 192.168.133.108 -P 3307
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.51 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
注意：外部客户端连接容器内数据库使用的是3307的端口.
参考网址：
https://www.bilibili.com/video/BV1mU4y1Z7Mp/?spm_id_from=333.337.search-card.all.click&vd_source=8c872e2fd1d99229b38a73ed6718b776docker下部署mysql 5.6.51
原创Liujun_Deng 博主文章分类：Mysql ©著作权
文章标签 mysql Docker docker部署mysql 文章分类 MySQL 数据库
©著作权归作者所有：来自51CTO博客作者Liujun_Deng的原创作品，请联系作者获取转载授权，否则将追究法律责任
提问和评论都可以，用心的回复会被更多人看到
评论
发布评论
相关文章
-
docker下部署nginx
1.首先，创建目录 nginx, 用于存放后面的相关东西mkdir -p /nginx/www /n
nginx html docker -
在Docker环境下部署Kafka
1、下载镜像这里使用了wurstmeister/kafka和wurstmeister/z
Docker 大数据 kafka zookeeper docker
