虚拟机建立mysql数据库

从docker hub上拉取mysql数据库镜像
刚开始用的是v8 版本，创建失败，改用的mysql:5.7.32
命令1：docker pull mysql:5.7.32
查看镜像是否拉取成功
命令2：docker images

[root@localhost ~]# docker images
REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
mysql               5.7.32              f07dfa83b528        3 weeks ago         448MB

命令3：启动mysql镜像
-e MYSQL_ROOT_PASSWORD=123456 设置root 用户的密码

[root@localhost ~]# docker run  -itd --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:5.7.32 
e0dcf7432f7118fcab3fe4f09eba1cd596a3ef06243df37b76b1007ff133ce02

命令4 ：查询镜像是否启动成功

[root@localhost ~]# docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                               NAMES
e0dcf7432f71        mysql:5.7.32        "docker-entrypoint.s…"   3 seconds ago       Up 1 second         0.0.0.0:3306->3306/tcp, 33060/tcp   mysql

命令5：进入交互界面

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

命令6：交互界面，启动mysql

root@e0dcf7432f71:/# mysql -h localhost -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.32 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, 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> 

命令7 ：创建数据库

mysql> create database activiti6ui
    -> ;
Query OK, 1 row affected (0.01 sec)

mysql>