数据库第三次

使用Docker安装Mysql

首先，从阿里云的Docker Hub 上pull一个MySQL的image.、

[centos@loovelj~]$ docker pull registry.cn-hangzhou.aliyuncs.com/acs-sample/mysql:5.7
5.7: Pulling from acs-sample/mysql
d4bce7fd68df: Pull complete 
a3ed95caeb02: Pull complete 
01588229585e: Pull complete 
ada32b818a1a: Pull complete 
ac7528e308ac: Pull complete 
44e3fb8779c7: Pull complete 
bfcca86efc6a: Pull complete 
32da415dff2e: Pull complete 
aae6d9712a36: Pull complete 
3148136ce9cc: Pull complete 
Digest: sha256:32ff2f404c3bd199aaec2e6d19d91d59673e40d7394732124f91dd72a2e1ed97
Status: Downloaded newer image for registry.cn-hangzhou.aliyuncs.com/acs-sample/mysql:5.7

查看下载镜像，就会看到已经有了

[centos@loovelj~]$ docker images
REPOSITORY                                           TAG                 IMAGE ID            CREATED             SIZE
test/ubuntu                                          v1.0                523e7db0e264        11 minutes ago      98.3MB
ubuntu                                               latest              dd6f76d9cc90        7 days ago          122MB
hello-world                                          latest              725dcfab7d63        8 days ago          1.84kB
registry.cn-hangzhou.aliyuncs.com/acs-sample/mysql   5.7                 ec7e75e5260c        23 months ago       360MB
 

 名 字太长，修改为短的tag

[centos@loovelj~]$ docker tag registry.cn-hangzhou.aliyuncs.com/acs-sample/mysql:5.7 mysql:5.7 
[centos@loovelj~]$ docker images
REPOSITORY                                           TAG                 IMAGE ID            CREATED             SIZE
test/ubuntu                                          v1.0                523e7db0e264        12 minutes ago      98.3MB
ubuntu                                               latest              dd6f76d9cc90        7 days ago          122MB
hello-world                                          latest              725dcfab7d63        8 days ago          1.84kB
mysql                                                5.7                 ec7e75e5260c        23 months ago       360MB
registry.cn-hangzhou.aliyuncs.com/acs-sample/mysql   5.7                 ec7e75e5260c        23 months ago       360MB

 根据镜像创建容器 

[centos@loovelj~]$ docker create -it mysql:5.7
62c975b37ad25b03914eb61e05088019f37ff9cb049a682ac02f20fac1761a4d

启动MYSQL容器

[centos@loovelj~]$ docker run --name mysqlserver -e MYSQL_ROOT_PASSWORD=sgcc -d -i -p 3306:3306  mysql:5.7
2a7a85124400be6fd47e0d97cf5d602456b1db1a11c6331747fe662481eea537
[centos@loovelj~]$ docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                    NAMES
2a7a85124400        mysql:5.7           "/entrypoint.sh my..."   9 seconds ago       Up 8 seconds        0.0.0.0:3306->3306/tcp   mysqlserver
188099665d1e        ubuntu:latest       "/bin/bash"              23 hours ago        Up 23 hours                                  angry_spence
 

进入MYSQL终端

[centos@liujun ~]$ docker exec -it  2a7a85124400  /bin/bash
root@2a7a85124400:/# mysql -h 127.0.0.1 -u root -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.9 MySQL Community Server (GPL)
 
Copyright (c) 2000, 2015, 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> 

3.访问Mysql数据库
由于我们在上面使用了-p参数映射了容器的3306端口到宿主机的3306端口，此时我们可以直接访问宿主机的3306端口来访问Docker中的mysql服务 

mysql -h 127.0.0.1 -u root -p