Docker命令、Docker安装SQLServer2019、Docker安装MySQL（持续更新）

Docker 常规命令

Docker常用操作：

命令不管用的时候在命令前面加上sudo

查看当前有些什么images

docker images

停止所有的images

sudo docker stop $(docker ps -a -q)

删除images，通过image的id来指定删除谁

docker rmi <image id>

查询容器ID，可以使用

docker images

列出所有容器

docker ps -all

搜索镜像

docker search [option] keyword

拉取镜像

docker pull mysql:5.7

报错分析：

[root@kvm ~]# docker rmi 4950a54ede5a
Error response from daemon: conflict: unable to delete 4950a54ede5a (must be forced) - image is being used by stopped container 834789a17497

报错原因：

image is being used by stopped container 834789a17497

解决方法

执行docker ps -a查看所有容器记录
执行命令docker rm container_ID删除这个容器
行命令docker rmi image_ID删除镜像

Mac利用Docker安装SqlServer2019

参考资料：微软官方教程：

https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash

1. 首先安装Docker容器，https://www.docker.com/

2. 从 Docker Hub 拉取 SQL Server 2019 Linux 容器映像。

   sudo docker pull mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
   

3. 运行Docker容器镜像。

   sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=<YourStrong@Passw0rd>" \
      -p 1433:1433 --name sql1 \
      -d mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
   

4. 修改默认密码

   sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \
      -S localhost -U SA -P "<YourStrong@Passw0rd>" \
      -Q 'ALTER LOGIN SA WITH PASSWORD="<YourNewStrong@Passw0rd>"'
   

5. 查看Docker容器状态

   docker ps -all
   

6. 如果发现容器状态为stopped，可以使用docker start xxxx激活sqlserver容器。

   现在已经可以使用类似DataGrip等工具连接SqlServer了。

Docker安装MySQL：

1. 从服务器拉取mysql镜像

   # $ docker pull mysql	最新版本
   $ docker pull mysql:5.7
   5.7: Pulling from library/mysql
   619014d83c02: Pull complete 
   9ced578c3a5f: Pull complete 
   731f6e13d8ea: Pull complete 
   3c183de42679: Pull complete 
   6de69b5c2f3c: Pull complete 
   00f0a4086406: Pull complete 
   84d93aea836d: Pull complete 
   e2dd1f3e5a3d: Pull complete 
   98fb37478ee6: Pull complete 
   57eb21662ebf: Pull complete 
   e95057f0a050: Pull complete 
   Digest: sha256:cf6899e980c38071a78ded028de40e65286bfbbb746b97617ac4c9a84c4e812d
   Status: Downloaded newer image for mysql:5.7
   docker.io/library/mysql:5.7
   

2. 启动Docker中镜像(3307端口)

   $ docker run --name mysql8.0 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=root -d mysql:5.7
   54127a27cd77a61d96f6f307f74023a5936c2e980f168449caa43aa652c3f3e7
   

3. 查看运行的镜像

   docker ps -a
   CONTAINER ID        IMAGE               COMMAND
   54127a27cd77        mysql:5.7           "docker-entrypoint.s…"
   

4. 进入镜像运行MySQL

   $ docker exec -it mysql8.0 /bin/bash
   $ cd /usr/bin
   $ mysql -u root -p
   Enter password: 
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   

5. 享受MySQL吧，亦可使用DataGrip进行连接

**注意：**日后可输入docker start mysql8.0启动镜像

卸载篇：

1. 查看已安装的MySql

   $ docker images
   REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
   mysql               5.7                 c4f186b9e038        19 hours ago        435MB
   

2. 删除镜像

   $ docker rmi c4f186b9e038
   Error response from daemon: conflict: unable to delete c4f186b9e038 (cannot be forced) - image is being used by running container 81cc051738ff
   

3. 显示为container仍在执行，首先关闭container，再进行删除container，再删除images

   $ docker ps -a
   CONTAINER ID        IMAGE               COMMAND                  CREATED
   81cc051738ff        mysql:5.7           "docker-entrypoint.s…"	 25 minutes ago
   $ docker rm 81cc051738ff
   Error response from daemon: You cannot remove a running container 81cc051738ff3353544ee8228e05931466996e6a6a284877658b007b99999fdb. Stop the container before attempting removal or force remove
   $ docker stop 81cc051738ff
   81cc051738ff
   $ docker rm 81cc051738ff 
   81cc051738ff
   $ docker rmi c4f186b9e038
   Untagged: mysql:5.7
   Untagged: mysql@sha256:cf6899e980c38071a78ded028de40e65286bfbbb746b97617ac4c9a84c4e812d
   Deleted: sha256:c4f186b9e038c856c5fb5f6b27ca106db3cc064594b7e5706d0350a3ab6220db
   Deleted: sha256:559aae5961538b4952716e0fe91c22b6dcf3f2743ce1edca8959397fb12ea199
   Deleted: sha256:35944f79a2417b0977238d183b56fb1b236c61a010fb5c2c59565e52f0852afc
   Deleted: sha256:89ed3af1b5b4e0a49bd7751151e7aed7ca6c0063159f60854bf4c9d42e9f1731
   Deleted: sha256:d814117c28ead6f61d30a3e07c4889526267400877bd3ef5b7d86bf0c94f5d6d
   Deleted: sha256:477e19600de637164faac8d2e39d4552fac8fbf3c4a9f29efe34072c0fd156e9
   Deleted: sha256:2c109aa38ef35164d5adcabac202bde92420867a5839deb75f5ce034aacc00b4
   Deleted: sha256:0de337169373e6779cb3ca09485e95fedd4ac98abee19b839cd46e294a64f363
   Deleted: sha256:73f1cb0f35d3377b825488e38241d0e12c63e7d30946362402dd8ab2e9467d81
   Deleted: sha256:5807022bbb80a63e78831d4dff1ac497a450287ce43fbb0381623b19f5d45c8a
   Deleted: sha256:1aaef8d601e09d40fc66f3531268e837f4ae3eedf84f94359fa33177f0be4c6e
   Deleted: sha256:e0db3ba0aaea8a01d5cb000aeb449c153be0a47a369cafc4e912b85fb18192cf
   

   4、完成