Docker安装Mysql服务

Docker安装Mysql服务：

1.检索mysql镜像

检索镜像命令：docker search mysql

2.拉取mysql镜像

拉取镜像命令：docker pull mysql

获取固定版本镜像：docker pull mysql:5.6

localhost:~ zhangjiankang$ docker pull mysql
Using default tag: latest
latest: Pulling from library/mysql
6ae821421a7d: Pull complete
a9e976e3aa6d: Pull complete
e3735e44a020: Pull complete
bfd564e9483f: Pull complete
df705f26e488: Pull complete
0c5547f73d62: Pull complete
f437382cf8a1: Pull complete
b8e2d50f1513: Pull complete
e2e3c9928180: Pull complete
b60db6d282cd: Pull complete
1d32deab69c6: Pull complete
408a40cd2e9c: Pull complete
Digest: sha256:a571337738c9205427c80748e165eca88edc5a1157f8b8d545fa127fc3e29269
Status: Downloaded newer image for mysql:latest

3.查询mysql镜像

查询镜像命令：docker images

删除镜像命令：docker rmi <image id>

4.用docker启动mysql容器

启动命令：docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6

宿主机创建目录：

mkdir /data/mysql/datadir

mkdir /data/mysql/conf.d

挂载命令：docker run --name mysql -v/data/mysql/datadir:/var/lib/mysql -v/data/mysql/conf.d:/etc/mysql/conf.d -p 3308:3306 -e MYSQL_ROOT_PASSWORD=Zjk@123 -d mysql

命令解析：
--name：容器名

--p：映射宿主主机端口 3308为对外访问端口

-v：挂载宿主目录到容器目录

-e：设置环境变量，此处指定root密码

-d：后台运行容器

mysql:5.6 为镜像名称和tag版本，如果是最新版本后缀可忽略

localhost:~ zhangjiankang$ docker run --name mysql5.6 -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6
200c73419302c7f032629449965ce4a2f73e12f1e1c9de920aa9193d3fa3fed3
localhost:~ zhangjiankang$ docker ps

5.安装成功

6.进入mysql容器

进入容器命令：docker exec -it mysql bash

登录MySQL命令：mysql -u root -p

localhost:~ zhangjiankang$ docker exec -it mysql5.6 bash
root@200c73419302:/# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.43 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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.
mysql>