docker+image+mysql_docker实例之mysql的使用

docker实例之mysql的使用

常用步骤

命令

1：搜索镜像

docker search xxx

2：拉取镜像

docker pull xxx:yy

3：查看镜像

docker image inspect xxx:yy

4：运行容器

docker run xxx:yy

5：停止容器

docker container stop ID

6：删除容器

docker container rm ID

演示:

1:搜索mysql镜像

[root@docker ~]# docker search mysql

NAME DESCRIPTION STARS OFFICIAL AUTOMATED

mysql MySQL is a widely used, open-source relation… 8864 [OK]

mariadb MariaDB is a community-developed fork of MyS… 3112 [OK]

mysql/mysql-server Optimized MySQL Server Docker images. Create… 655 [OK]

......

2:拉取镜像

[root@docker ~]# docker pull mysql:5.7

5.7: Pulling from library/mysql

d599a449871e: Pull complete

f287049d3170: Pull complete

08947732a1b0: Pull complete

96f3056887f2: Pull complete

871f7f65f017: Pull complete

1dd50c4b99cb: Pull complete

5bcbdf508448: Pull complete

02a97db830bd: Pull complete

c09912a99bce: Pull complete

08a981fc6a89: Pull complete

818a84239152: Pull complete

Digest: sha256:5779c71a4730da36f013a23a437b5831198e68e634575f487d37a0639470e3a8

Status: Downloaded newer image for mysql:5.7

docker.io/library/mysql:5.7

[root@docker ~]# docker image ls -a

[root@docker ~]# docker images

REPOSITORY TAG IMAGE ID CREATED SIZE

mysql 5.7 1e4405fe1ea9 4 days ago 437MB

3:查看镜像信息

[root@docker ~]# docker image inspect 1e44

...

4:启动一个容器

[root@docker ~]# docker run -p 12345:3306 --name mysql -v /root/mysql/conf:/etc/mysql/conf.d -v /root/mysql/logs:/logs -v /root/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

fc136870a6baf32639f08a5f4c545aaca26815cecc0c26018184b86b36c72531

[root@docker ~]# docker container ls -a

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

fc136870a6ba mysql:5.7 "docker-entrypoint.s…" 18 seconds ago Up 12 seconds 33060/tcp, 0.0.0.0:12345->3306/tcp mysql

#命令说明：

-p[小写]：将主机的 12345端口映射到容器内部端口3306

--name：设置别名 mysql

-v /root/mysql/conf:/etc/mysql/conf.d

-v /root/mysql/logs:/logs

-v /root/mysql/data:/var/lib/mysql

-e MYSQL_ROOT_PASSWORD=123456 #初始化root用户密码

-d mysql:5.7 #后台运行

5：进入容器并使用mysql

[root@docker ~]# docker exec -it fc136870a6ba /bin/bash

root@fc136870a6ba:/#

root@fc136870a6ba:/# mysql -uroot -p

Enter password: #123456前面设置的

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.28 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.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

#成功进入mysql客户端

mysql> show databases; #显示数据库

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

+--------------------+

4 rows in set (0.00 sec)

mysql> create database db01; #创建一个数据库

Query OK, 1 row affected (0.00 sec)

mysql> show databases ;

+--------------------+

| Database |

+--------------------+

| information_schema |

| db01 |

| mysql |

| performance_schema |

| sys |

+--------------------+

5 rows in set (0.00 sec)

mysql> use db01; #切换数据库

Database changed

mysql> create TABLE mybook (id int not null primary key,name char(15),price int,pages int); #建表

Query OK, 0 rows affected (0.13 sec)

mysql> DESCRIBE mybook; #查询表结构

+-------+----------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+----------+------+-----+---------+-------+

| id | int(11) | NO | PRI | NULL | |

| name | char(15) | YES | | NULL | |

| price | int(11) | YES | | NULL | |

| pages | int(11) | YES | | NULL | |

+-------+----------+------+-----+---------+-------+

4 rows in set (0.24 sec)

mysql> INSERT INTO mybook(id,name,price,pages) VALUES('1','docker','60','438'); #插入一条数据

Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM mybook; #查询数据

+----+--------+-------+-------+

| id | name | price | pages |

+----+--------+-------+-------+

| 1 | docker | 60 | 438 |

+----+--------+-------+-------+

1 row in set (0.00 sec)

mysql> quit

Bye

root@fc136870a6ba:/# read escape sequence

[root@docker ~]#

[root@docker ~]# docker ps -al

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

fc136870a6ba mysql:5.7 "docker-entrypoint.s…" 27 minutes ago Up 27 minutes 33060/tcp, 0.0.0.0:12345->3306/tcp mysql

[root@docker ~]#

mysql练习结束

6：使用win主机上的Navicat for MySQL 连接 虚拟机中运行的mysql容器

1:找到容器运行的主机的IP地址

[root@docker ~]# ifconfig eno16777728 |grep broad | sed 's/inet//' |sed 's/netmask.*//'

192.168.1.10

2:在win主机中远程连接

数据和刚刚在容器中的生成的一样，成功。