基于docker安装MySQL

目录

1. 查看要安装的MySQL

2. 拉取MySQL镜像

3. 根据镜像创建mysql容器

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

---

1. 查看要安装的MySQL

#  docker search mysql 

dockerhub地址Docker Hub

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 \                                             -v /daya/mysql/conf:/etc/mysql/conf.d \
 -v /data/mysql/data:/var/lib/mysql \
 -v /data/mysql/logs:/var/log \
 -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 \
-v /daya/mysql/conf:/etc/mysql/conf.d \
-v /data/mysql/data:/var/lib/mysql \
-v /data/mysql/logs:/var/log \
-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 工具进行连接