用docker创建mysql容器

  一个container 是基于一个镜像文件来启动的，下载好镜像，然后创建好container，启动，然后进入container

[root@VM-0-4-centos ~]# docker pull mysql:8     //下载mysql8版本 8: Pulling from library/mysql Digest: sha256:92d27b8222bbcf53bc42c70ca7cd1010d6c0527efc61f14980ce77c50932bef4 Status: Downloaded newer image for mysql:8 docker.io/library/mysql:8 [root@VM-0-4-centos ~]# docker image ls      //显示系统中已经有的镜像文件 REPOSITORY   TAG       IMAGE ID       CREATED      SIZE mysql        8         d1dc36cf8d9e   2 days ago   519MB mysql        latest    d1dc36cf8d9e   2 days ago   519MB [root@VM-0-4-centos ~]# docker create -p 3307:3306 --name mydiarydatabase -e MYSQL_ROOT_PASSWORD=root mysql:8 //3307是宿主机的端口3306是container的 container名称为mydiarydatabase root账号的密码为root  用mysql:8这个镜像创建container 43a89af48886895f821f106aaae4426dab55d8528092a66b63ce00d90d4f62c2 [root@VM-0-4-centos ~]# docker container ls -a      //显示全量的container CONTAINER ID   IMAGE          COMMAND                  CREATED             STATUS             PORTS                                                  NAMES 43a89af48886   mysql:8        "docker-entrypoint.s…"   13 seconds ago      Created                                                                   mydiarydatabase 99a9ce1105e8   mysql:latest   "docker-entrypoint.s…"   About an hour ago   Up About an hour   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysqld1 e7353b445a53   mysql:latest   "docker-entrypoint.s…"   About an hour ago   Created                                                                   mysqld2 [root@VM-0-4-centos ~]# docker start mydiarydatabase      //启动container mydiarydatabase [root@VM-0-4-centos ~]# docker exec -it mydiarydatabase bash        //进入container root@43a89af48886:/# mysql -uroot -p  Enter password:  Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.28 MySQL Community Server - GPL Copyright (c) 2000, 2022, Oracle and/or its affiliates. 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> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | sys                | +--------------------+ 4 rows in set (0.00 sec)