Docker安装 Mysql

想当厨子的小章同学

已于 2024-06-13 17:22:37 修改

阅读量195

点赞数

分类专栏： mysql 文章标签： mysql docker 数据库

于 2023-02-13 11:06:29 首次发布

本文链接：https://blog.youkuaiyun.com/zhangli_li520/article/details/127757162

版权

mysql 专栏收录该内容

8 篇文章

订阅专栏

Docker 安装 Mysql5.7

docker run -p 38xx:3306 --name mysql5.7 \
 -v /usr/local/docker/mysql5.7/conf:/etc/mysql/conf.d \
 -v /usr/local/docker/mysql5.7/logs:/var/log/mysql \
 -v /usr/local/docker/mysql5.7/data:/var/lib/mysql \
 -e MYSQL_ROOT_PASSWORD=xxxxx \
 -d mysql:5.7.20 \
 --character-set-server=utf8mb4 \
 --collation-server=utf8mb4_unicode_ci

Docker 安装 Mysql8.0

docker run -p 38xx:3306 --name mysql8.1 \
 -v /usr/local/docker/mysql8.1/conf:/etc/mysql \
 -v /usr/local/docker/mysql8.1/logs:/var/log/mysql \
 -v /usr/local/docker/mysql8.1/data:/var/lib/mysql-files \
 -e MYSQL_ROOT_PASSWORD=adxxxxxx \
 -d mysql:8.0.28 \
 --character-set-server=utf8mb4 \
 --collation-server=utf8mb4_unicode_ci \
 --lower_case_table_names=1

mysql 8.0 安装完成后使用 sqlyog 连接会报错
在这里插入图片描述
这是因为MYSQL8.0之后更换了加密规则为caching_sha2_password,8.0之前则为mysql_native_password

登录到docker mysql 容器内执行mysql sql 将其修改

[root@iZbp14qrdskvwq54fj9a2jZ ~]# docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED              STATUS              PORTS                               NAMES
b4d96a8ce8ca        mysql:5.7.20        "docker-entrypoint..."   6 seconds ago        Up 5 seconds        0.0.0.0:3857->3306/tcp              mysql5.7
5feeff47e414        mysql:8.0.28        "docker-entrypoint..."   About a minute ago   Up About a minute   33060/tcp, 0.0.0.0:3881->3306/tcp   mysql8.1

[root@iZbp14qrdskvwq54fj9a2jZ ~]# docker exec -it 5feeff47e414 bin/bash
root@5feeff47e414:/# mysql -u root -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)

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'adxxxxxx';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql>

修改完测试连接成功
在这里插入图片描述

-d 后台运行
-p 端口映射。-p 3306:3306 ：映射容器服务的 3306 端口到宿主机的 3306 端口，外部主机可以直接通过宿主机ip:3306 访问到 MySQL 的服务
-v 卷挂载。 /usr/local/mysql/conf:/etc/mysql/conf.d ：将到本地 /usr/local/mysql/conf挂载到容器的 /etc/mysql/my.cnf。后面修改配置文件，只需要再本地 /usr/local/mysql/conf修改即可，不需要进入容器里面进行修改
-e 环境配置。 -e MYSQL_ROOT_PASSWORD=123456 配置数据库连接密码为123456
–name 容器名字