基于docker安装MySQL

目录

1. 查看要安装的MySQL

2. 拉取MySQL镜像

3. 根据镜像创建mysql容器

4. 进入容器内部并测试mysql是否创建成功

1. 查看要安装的MySQL

#  docker search mysql 

dockerhub地址https://hub.docker.com/_/mysql

2. 拉取MySQL镜像

#  docker pull mysql

[root@iZ2zeejocu3f80bljfr5fdZ ~]# docker pull mysql
Using default tag: latest
latest: Pulling from library/mysql
Digest: sha256:6d7d4524463fe6e2b893ffc2b89543c81dec7ef82fb2020a1b27606666464d87
Status: Image is up to date for mysql:latest
docker.io/library/mysql:latest
[root@iZ2zeejocu3f80bljfr5fdZ ~]# 

3. 根据镜像创建mysql容器

# docker run -itd --name mysql --restart always --privileged=true
  -p 3306:3306 -e MYSQL_ROOT_PASSWORD=admin 
  mysql --character-set-server=utf8 --collation-server=utf8_general_ci

[root@iZ2zeejocu3f80bljfr5fdZ ~]# docker run -itd --name mysql --restart always --privileged=true 
> -p 3306:3306 -e MYSQL_ROOT_PASSWORD=admin 
>  mysql --character-set-server=utf8 --collation-server=utf8_general_ci
6ffd0507b1b1dcec967ccb7df4fbb077021c2dea9857e5e122fdc0df6d36a0e5
[root@iZ2zeejocu3f80bljfr5fdZ ~]# 

-e MYSQL_ROOT_PASSWORD=admin  设置数据库密码

--character-set-server=utf8 --collation-server=utf8_general_ci   设置编码格式

4. 进入容器内部并测试mysql是否创建成功

# j进入容器内部

docker exec -it mysql  /bin/bash

# 连接mysql 

mysql -uroot -p 

[root@iZ2zeejocu3f80bljfr5fdZ ~]# docker exec -it mysql /bin/bash
root@23400bd040c5:/# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 148
Server version: 8.0.27 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |            
| mysql              |            
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> 

也可以使用Navicat 工具进行连接