docker基础——mysql安装

最新推荐文章于 2024-11-12 11:41:10 发布
最新推荐文章于 2024-11-12 11:41:10 发布
阅读量149 收藏
点赞数
分类专栏： docker 文章标签： mysql docker 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_33650193/article/details/129486235
版权

运行本地仓库

[root@localhost ~]# docker run -d -p 5000:5000 -v /jl/myregistry/:/tmp/registry --privileged=true registry         
f5bbe411a1ed3441bf1fa02babd913e34bf948330af17ab7a6f9c45a0cf4a13a
[root@localhost ~]# docker ps               
CONTAINER ID   IMAGE      COMMAND                  CREATED         STATUS         PORTS                                       NAMES
f5bbe411a1ed   registry   "/entrypoint.sh /etc…"   4 seconds ago   Up 3 seconds   0.0.0.0:5000->5000/tcp, :::5000->5000/tcp   gallant_driscoll
[root@localhost ~]#

简单版

[root@localhost ~]# docker search mysql:5.7
NAME                                      DESCRIPTION                                     STARS     OFFICIAL   AUTOMATED
kiratalent/mysql                          Pinned copy of mysql:5.7.24                     1                    
migs/mysql-5.7                            mysql:5.7 plus some basic enhancements          0                    [OK]
xiao806852034/mysql57                     基于 mysql:5.7                                  0                    
idyci/mysql                               mysql:5.7.25                                    1                    
framgiaciteam/mysql-256                   FROM mysql:5.7  CMD ["--block_encryption_mod…   0                    
metatronx/mysql                           mysql:5.7 + druid account & database            0                    
haswind/mysql                             mysql:5.7                                       0                    
stsiwo/sts-blog-db                        base image mysql:5.7.28                         0                    
llasuka/mysql                             mysql:5.7                                       0                    
michaelzx/docker_msyql                    without ONLY_FULL_GROUP_BY base on mysql:5.7…   0                    [OK]
alexmbarbosa/mysql5.7                     Based on official mysql:5.7 docker image        0                    
alecchyi/mysql                            mysql:5.7 for demo                              0                    
denghui/mysql                             mysql:5.7-tz.8                                  0                    [OK]
crbanman/mysql-tmpfs                      A docker image based off of mysql:5.7 that m…   0                    
vigasin/mysql                             Clone of official mysql:5.7 image, that allo…   0                    
variu/hyperledger-explorer-mysql          mysql:5.7.23 for hyperledger explorer           0                    
doctorva/mysql_fede                       Based on Mysql:5.7 and add new configuration…   0                    
ahmedelshfie/spring-boot-mysql-rest-api   mysql:5.7                                       0                    
zhjs/mysql                                mysql:5.7                                       0                    
beyondray/kbengine-mysql                  kbengine auto-build env from mysql:5.7          0                    [OK]
liyupei/mysql                             Mysql:5.7                                       0                    
kamatimaru/mysql57-ja                     Added Japanese support settings to mysql:5.7…   0                    
zeq9069/mysql_service                     mysql:5.7                                       0                    
ruyli/mysql                               mysql:5.7                                       0                    
dockerzm/mysql                            docker run --name mysql -e MYSQL_ROOT_PASSWO…   0                    
[root@localhost ~]# 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@localhost ~]# docker images
REPOSITORY                      TAG       IMAGE ID       CREATED         SIZE
192.168.253.128:5000/jlubuntu   1.2       09f66e5eb0c6   4 days ago      115MB
jlubuntu                        1.2       09f66e5eb0c6   4 days ago      115MB
jlubuntu                        1.2.1     09f66e5eb0c6   4 days ago      115MB
mysql                           5.7       c20987f18b13   15 months ago   448MB
registry                        latest    b8604a3fe854   17 months ago   26.2MB
ubuntu                          latest    ba6acccedd29   18 months ago   72.8MB
hello-world                     latest    feb5d9fea6a5   18 months ago   13.3kB
redis                           6.0.8     16ecd2772934   2 years ago     104MB
billygoo/tomcat8-jdk8           latest    30ef4019761d   4 years ago     523MB
[root@localhost ~]# docker run -p 3306:3306 -e MYSQL ROOT PASSWORD=123456 -d mysql:5.7
docker: invalid reference format: repository name must be lowercase.
See 'docker run --help'.
[root@localhost ~]# docker run -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7  
5df5690d650fd6d61440a20d8136b07a6cbea313400e90fc98bd951fa23e41d4
[root@localhost ~]# docker ps
CONTAINER ID   IMAGE       COMMAND                  CREATED          STATUS          PORTS                                                  NAMES
5df5690d650f   mysql:5.7   "docker-entrypoint.s…"   8 seconds ago    Up 7 seconds    0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   amazing_napier
f5bbe411a1ed   registry    "/entrypoint.sh /etc…"   29 minutes ago   Up 29 minutes   0.0.0.0:5000->5000/tcp, :::5000->5000/tcp              gallant_driscoll
[root@localhost ~]# docker exec -it 5df5690d650f bash
root@5df5690d650f:/# mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.05 sec)

mysql> exit
Bye
root@5df5690d650f:/#

在这里插入图片描述
navicate连接数据库插入中文失败

在这里插入图片描述

问题：

docker上默认字符编码隐患
删除容器后数据无法恢复

完善版

[root@localhost ~]# docker ps
CONTAINER ID   IMAGE       COMMAND                  CREATED             STATUS             PORTS                                                  NAMES
5df5690d650f   mysql:5.7   "docker-entrypoint.s…"   48 minutes ago      Up 48 minutes      0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   amazing_napier
f5bbe411a1ed   registry    "/entrypoint.sh /etc…"   About an hour ago   Up About an hour   0.0.0.0:5000->5000/tcp, :::5000->5000/tcp              gallant_driscoll
[root@localhost ~]# docker rm -f 5df5690d650f
5df5690d650f
[root@localhost ~]# docker ps
CONTAINER ID   IMAGE      COMMAND                  CREATED             STATUS             PORTS                                       NAMES
f5bbe411a1ed   registry   "/entrypoint.sh /etc…"   About an hour ago   Up About an hour   0.0.0.0:5000->5000/tcp, :::5000->5000/tcp   gallant_driscoll
//通过容器卷实现数据同步
[root@localhost ~]# docker run -d -p 3306:3306 --privileged=true -v /jl/mysql/log:/var/log/mysql -v /jl/mysql/data:/var/lib/mysql -v /jl/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 --name mysql mysql:5.7                           
cd096afd198eac83a4bed333af9337d3eb0a59d3d94cab6d14176d0cfb64f411
[root@localhost ~]# docker ps
CONTAINER ID   IMAGE       COMMAND                  CREATED             STATUS             PORTS                                                  NAMES
cd096afd198e   mysql:5.7   "docker-entrypoint.s…"   7 seconds ago       Up 5 seconds       0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql
f5bbe411a1ed   registry    "/entrypoint.sh /etc…"   About an hour ago   Up About an hour   0.0.0.0:5000->5000/tcp, :::5000->5000/tcp              gallant_driscoll
[root@localhost ~]# ^C
[root@localhost ~]# cd /jl/mysql/conf/
新建my.cnf文件
[root@localhost conf]# vi  my.cnf
[root@localhost conf]# cat my.cnf 
[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8
[root@localhost conf]# docker ps
CONTAINER ID   IMAGE       COMMAND                  CREATED       STATUS       PORTS                                                  NAMES
cd096afd198e   mysql:5.7   "docker-entrypoint.s…"   2 hours ago   Up 2 hours   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql
f5bbe411a1ed   registry    "/entrypoint.sh /etc…"   4 hours ago   Up 4 hours   0.0.0.0:5000->5000/tcp, :::5000->5000/tcp              gallant_driscoll
[root@localhost conf]# docker restart mysql
mysql
[root@localhost conf]# docker exec -it mysql bash
root@cd096afd198e:/# mysqi -uroot -p123456
bash: mysqi: command not found
root@cd096afd198e:/# mysql -uroot -p123456 
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
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> SHOW VARIABLES LIKE 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.25 sec)

mysql>

navicat插入中文还是报错：
在这里插入图片描述

alter table userinfo change username username varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT ‘json’ NOT NULL;
在这里插入图片描述

[root@localhost conf]# docker exec -it mysql bash
root@cd096afd198e:/# mysqi -uroot -p123456
bash: mysqi: command not found
root@cd096afd198e:/# mysql -uroot -p123456 
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
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> SHOW VARIABLES LIKE 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.25 sec)

mysql> ^C
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from userinfo;
+----+----------+-------------+
| id | username | tel         |
+----+----------+-------------+
|  1 | jl2      | 17854289303 |
|  2 | ll       | 17854289303 |
|  3 | 记录     | 17854289303 |
+----+----------+-------------+
3 rows in set (0.00 sec)

mysql>

测试容器卷数据同步

[root@localhost conf]# docker rm -f mysql
mysql
[root@localhost conf]# docker run -d -p 3306:3306 --privileged=true -v /jl/mysql/log:/var/log/mysql -v /jl/mysql/data:/var/lib/mysql -v /jl/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 --name mysql mysql:5.7       
7e477af1061c3f6a4287383bb79fc771357dc4faf747b915854796836ac49571
[root@localhost conf]# docker ps  
CONTAINER ID   IMAGE       COMMAND                  CREATED         STATUS         PORTS                                                  NAMES
7e477af1061c   mysql:5.7   "docker-entrypoint.s…"   5 seconds ago   Up 4 seconds   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql
f5bbe411a1ed   registry    "/entrypoint.sh /etc…"   4 hours ago     Up 4 hours     0.0.0.0:5000->5000/tcp, :::5000->5000/tcp              gallant_driscoll
[root@localhost conf]# docker exec -it mysql bash
root@7e477af1061c:/# mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
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 mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from userinfo;
+----+----------+-------------+
| id | username | tel         |
+----+----------+-------------+
|  1 | jl2      | 17854289303 |
|  2 | ll       | 17854289303 |
|  3 | 记录     | 17854289303 |
+----+----------+-------------+
3 rows in set (0.00 sec)

mysql>
潇潇挽歌醉
关注
专栏目录
MySQL5.7安装教程
aiains的博客
10-31 9298
记录一下MySQL5.7的msi版本的下载与安装教程，MySQL8.0的msi版本也可参考本教程进行安装
Castor概述
duzhiteng的专栏
10-07 1126
Castor 是ExoLab Group下面的一个开放源代码的项目，它主要实现的是O/R映射功能。它主要API和数据接口为：JDO-like, SQL, OQL, JDBC, LDAP, XML, DSML。它支持分布式目录事务处理和时间；提供处理XML、Directory、XADirectory的类库，提供从XML到JAVA类的转换机制。 上面这段是网上的一段评论，大概介绍了Castor
Docker——mysql安装
weixin_42789698的博客
02-24 38
安装mysql
Docker 基础——镜像
m0_74197695的博客
08-17 1190
在自定义网络中，可以给容器起多个别名，默认的别名是容器名本身在同一个自定义网络中的容器，可以通过别名互相访问。
Docker教程——Docker安装
霖hero
05-29 510
在安装Docker之前，我们需要执行如下代码安装Docker的一些依赖包，依赖包安装好后，执行如下代码安装Docker，遇到提示时，输入y即可。安装完毕后，执行如下代码，判断安装是否成功，
【Docker】安装MySQL
热门推荐
你不来，再美的天地，都狼藉 ~
05-11 1万+
一文带你使用Docker安装MySQL，过关斩将。
Docker——安装MySQL
白白白鲤鱼的博客
06-16 2006
Docker——安装MySQL
docker 应用 —— docker 安装mysql
猎人在吃肉
12-19 1497
1、查询 mysql docker search mysql [root@iz2zei0x4t16rv0e5buzvhz /]# docker search mysql NAME DESCRIPTION STARS ...
Docker——MySQL部署
weixin_50616848的博客
04-16 1020
1、MySQL部署原理： 用户无法直接访问容器中的MySQL的3306端口，但是用户可以访问容器宿主机的33306端口，通过宿主机与容器端口映射，间接访问MySQL容器中的3306端口，如下图： 2、MySQL部署实现： （1）拉取mysql镜像： docker pull centos/mysql-57-centos7 （2）创建容器： -p：代表端口映射； -e：代表添加环境变量，MYSQL_ROOT_PASSWORD 是root用户远程登陆密码。 ......
Docker Compose——MySQL 8.x，adminer，gitlab，Jenkins，tomcat
https://hibernation0814.github.io/
12-06 188
Docker Compose环境搭建——MySQL 8.x，adminer，gitlab，Jenkins，tomcat服务，可用
5.Docker入门笔记——安装MySQL示例
java阳旭的博客
06-17 282
安装MySQL示例
Docker最新超详细教程——Docker创建运行MySQL并挂载
金鳞踏雨
07-26 3355
Docker最新超详细教程——Docker创建运行MySQL并挂载 （1）拉取mysql镜像 （2）创建目录 （3）运行mysql容器 自定义MySQL 配置文件 mysql-conf 存储数据的位置 mysql-data （4）测试数据库连接
MySQL中字段类型和Java对象中的数据类型对应关系
Zhuxiaoyu_91的博客
11-12 352
MySQL中字段类型和Java对象中的数据类型对应关系
./mysqld: error while loading shared libraries: libaio.so.1: cannot open sha
qq_42112846的博客
11-12 325
使用离线方式安装：rpm -ivh --nodeps mysql* ，执行 systemctl start mysqld.service发现启动不了，通过vi /var/log/mysql.log看到如下关键字：libraries: libaio.so.1，之前也是按照网上帖子各种修改都没有解决问题，库是Linux异步I/O库，这个库对MySQL是必需的，因为它依赖于这个库来进行异步I/O操作。2，如果执行了whereis libaio.so.1，没有找到该文件，就要手动安装下libaio。
MySQL库操作
zgwnb666的博客
11-08 987
MySQL库操作
MySQL分区
最新发布
这个人很懒，什么都没有留下。
11-12 711
分区实际上是提供了一种物理上的数据组织方式，使得查询操作能够更加聚焦于相关的数据段，避免了全表扫描，从而提升了查询效率，特别是在数据量非常大的情况下。这种方式特别适合于那些可以根据某些明显的业务逻辑（如时间、地区等）被分割的大表。
ReactPress 安装指南：从 MySQL 安装到项目启动
小牛itbull的博客
11-10 671
ReactPress 是一个基于 React 的开源发布平台，适用于搭建博客、网站或内容管理系统（CMS）。本文将详细介绍如何安装 ReactPress，包括 MySQL 数据库的安装、ReactPress 项目的配置与启动，并特别指出使用 pnpm 而不是 yarn 作为包管理工具。
使用Docker-compose安装mysql5.7
州仔
11-08 291
1.首先选择一个目录用来存放docker-compse文件以及mysql的数据（例如logs、conf）docker发现没有mysql5.7这个镜像会去自动下载，执行完以后MySQL启动成功。2.填写docker-compse.yml内容。宿主机需要开放3306端口。
Docker快速搭建MySQL(Percona)与MybatisPlus后台服务教程
在本教程中，我们将探讨如何利用Docker来安装MySQL的一个衍生版本——Percona Server。Percona Server是MySQL的增强版，提供了更好的性能和诊断工具，特别适合高负载环境。虽然它不包含对MySQL客户端或GUI工具的改进...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值