Docker安装Mysql服务

比眉伴天荒 2022-03-16 04:18 170阅读 0赞

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 3306:3306 -e MYSQL\_ROOT\_PASSWORD=123456 -d mysql:5.6

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

\--p：映射宿主主机端口

\-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.安装成功

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTEzMDE2OTIxOA_size_16_color_FFFFFF_t_70][]

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>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTEzMDE2OTIxOA_size_16_color_FFFFFF_t_70]: /images/20220316/69d217de5a87465db84f189a112c2222.png