Docker部署Mysql

目录

1.拉取Mysql镜像

2.创建Mysql容器 

3.进入Mysql容器，登录mysql

4. 查看Mysql信息日志

5.在自己的电脑上连接数据库

 6.在Xshell7里面测试

---

---

1.拉取Mysql镜像

[root@VM-0-10-centos ~]# docker pull mysql:5.7
5.7: Pulling from library/mysql
72a69066d2fe: Pull complete 
93619dbc5b36: Pull complete 
99da31dd6142: Pull complete 
626033c43d70: Pull complete 
37d5d7efb64e: Pull complete 
ac563158d721: Pull complete 
d2ba16033dad: Pull complete 
0ceb82207cd7: Pull complete 
37f2405cae96: Pull complete 
e2482e017e53: Pull complete 
70deed891d42: Pull complete 
Digest: sha256:f2ad209efe9c67104167fc609cca6973c8422939491c9345270175a300419f94
Status: Downloaded newer image for mysql:5.7
docker.io/library/mysql:5.7

查看已经拉取的镜像

[root@VM-0-10-centos ~]# docker images
REPOSITORY    TAG       IMAGE ID       CREATED        SIZE
nginx         latest    605c77e624dd   2 weeks ago    141MB
mysql         5.7       c20987f18b13   3 weeks ago    448MB
hello-world   latest    feb5d9fea6a5   3 months ago   13.3kB
[root@VM-0-10-centos ~]# 

2.创建Mysql容器 

[root@VM-0-10-centos ~]#  docker run --name testmysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=rootpassword -d  mysql:5.7
7e88091113e5e5b5137e795dc1af8a27d2f78252bd5138cabc5a7b9508f43431

3.进入Mysql容器，登录mysql

#进入testmysql容器
[root@VM-0-10-centos ~]# docker exec -it testmysql bash
root@7e88091113e5:/# 

#登录数据库
root@7e88091113e5:/# 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.7.36 MySQL Community Server (GPL)

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

#查看数据库
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql> 

4. 查看Mysql信息日志

[root@VM-0-10-centos ~]# docker logs testmysql

5.在自己的电脑上连接数据库

 

 6.在Xshell7里面测试

[root@VM-0-10-centos ~]# docker exec -it testmysql bash
root@7e88091113e5:/# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.7.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, 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> use mall
Database changed

其中mall是新建的数据库。