使用docker镜像跑一个mysql

小咪咪 2022-01-31 10:41 144阅读 0赞

**查找mysql镜像**：

[root@yhcookie ~]# docker search mysql
    NAME                                                   DESCRIPTION                                     STARS               OFFICIAL            AUTOMATED
    mysql                                                  MySQL is a widely used, open-source relation…   8147                [OK]                
    mariadb                                                MariaDB is a community-developed fork of MyS…   2775                [OK]                
    mysql/mysql-server                                     Optimized MySQL Server Docker images. Create…   607                                     [OK]
    zabbix/zabbix-server-mysql                             Zabbix Server with MySQL database support       192                                     [OK]
    hypriot/rpi-mysql                                      RPi-compatible Docker Image with Mysql          113                                     
    zabbix/zabbix-web-nginx-mysql                          Zabbix frontend based on Nginx web-server wi…   101                                     [OK]
    centurylink/mysql                                      Image containing mysql. Optimized to be link…   60                                      [OK]
    centos/mysql-57-centos7                                MySQL 5.7 SQL database server                   53                                      
    1and1internet/ubuntu-16-nginx-php-phpmyadmin-mysql-5   ubuntu-16-nginx-php-phpmyadmin-mysql-5          50                                      [OK]
    mysql/mysql-cluster                                    Experimental MySQL Cluster Docker images. Cr…   44                                      
    tutum/mysql                                            Base docker image to run a MySQL database se…   32                                      
    zabbix/zabbix-web-apache-mysql                         Zabbix frontend based on Apache web-server w…   29                                      [OK]
    schickling/mysql-backup-s3                             Backup MySQL to S3 (supports periodic backup…   27                                      [OK]
    bitnami/mysql                                          Bitnami MySQL Docker Image                      26                                      [OK]
    zabbix/zabbix-proxy-mysql                              Zabbix proxy with MySQL database support        22                                      [OK]
    linuxserver/mysql                                      A Mysql container, brought to you by LinuxSe…   20                                      
    centos/mysql-56-centos7                                MySQL 5.6 SQL database server                   13                                      
    mysql/mysql-router                                     MySQL Router provides transparent routing be…   11                                      
    circleci/mysql                                         MySQL is a widely used, open-source relation…   11                                      
    openshift/mysql-55-centos7                             DEPRECATED: A Centos7 based MySQL v5.5 image…   6                                       
    dsteinkopf/backup-all-mysql                            backup all DBs in a mysql server                6                                       [OK]
    jelastic/mysql                                         An image of the MySQL database server mainta…   1                                       
    ansibleplaybookbundle/mysql-apb                        An APB which deploys RHSCL MySQL                0                                       [OK]
    cloudposse/mysql                                       Improved `mysql` service with support for `m…   0                                       [OK]
    widdpim/mysql-client                                   Dockerized MySQL Client (5.7) including Curl…   0                                       [OK]
    [root@yhcookie ~]#

**拉取镜像**：

[root@yhcookie ~]# docker pull mysql:latest
    latest: Pulling from library/mysql
    743f2d6c1f65: Pull complete 
    3f0c413ee255: Pull complete 
    aef1ef8f1aac: Pull complete 
    f9ee573e34cb: Pull complete 
    3f237e01f153: Pull complete 
    f9da32e8682a: Pull complete 
    4b8da52fb357: Pull complete 
    3416ca8f6890: Pull complete 
    786698c2d5de: Pull complete 
    4ddf84d07bd1: Pull complete 
    cd3aa23461b6: Pull complete 
    9f287a2a95ad: Pull complete 
    Digest: sha256:711df5b93720801b3a727864aba18c2ae46c07f9fe33d5ce9c1f5cbc2c035101
    Status: Downloaded newer image for mysql:latest
    [root@yhcookie ~]#

docker run -d --name mytest-mysql -e MYSQL\_ROOT\_PASSWORD=root -p 3306:3306 mysql:latest

\--name ‘自定义的容器名’

MYSQL\_ROOT\_PASSWORD=‘自定义的root用户密码’

3306:3306 前者是你当前主机的3306端口，后者是当前容器中的3306端口。

**运行一个容器**

[root@yhcookie ~]# docker run --name mytest-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql
    b58c76de9b23ccc906925146a3925b26299fce20bb6aa3034fd4142696bd3e00

**\#\#进入容器**

docker exec -it mytest-mysql /bin/bash

[root@yhcookie ~]# docker exec -it mytest-mysql /bin/bash
    root@b58c76de9b23:/#

进入容器之后 就相当于进入了一个装有mysql的linux系统，可进行相应的操作，如：

root@b58c76de9b23:/# mysql -uroot -p123456
    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 11
    Server version: 8.0.16 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>

![20190604173833217.png][]

[20190604173833217.png]: /images/20220131/3dd5010762004a4d96366a4fb8e3120f.png