Warning: Trying to access array offset on value of type bool in /www/wwwroot/www.techfd.cn/wp-content/themes/onenav/inc/clipimage.php on line 29
Docker安装MySQL和Redis - 风动导航

Docker安装MySQL和Redis

网络技术8个月前更新 fdadmin
4,755 0 0

Docker安装请参考:https://www.jianshu.com/p/64de448b637c

1、Docker安装MySQL

1.1、Docker仓库中拉取MySQL镜像
[root@localhost ~]# docker pull mysql:5.7
5.7: Pulling from library/mysql
a076a628af6f: Pull complete 
f6c208f3f991: Pull complete 
88a9455a9165: Pull complete 
406c9b8427c6: Pull complete 
7c88599c0b25: Pull complete 
25b5c6debdaf: Pull complete 
43a5816f1617: Pull complete 
1831ac1245f4: Pull complete 
37677b8c1f79: Pull complete 
27e4ac3b0f6e: Pull complete 
7227baa8c445: Pull complete 
Digest: sha256:b3d1eff023f698cd433695c9506171f0d08a8f92a0c8063c1a4d9db9a55808df
Status: Downloaded newer image for mysql:5.7
docker.io/library/mysql:5.7
[root@localhost ~]#
1.2、启动MySQL容器

–name指定容器名字 -v目录挂载 -p指定端口映射 -e设置mysql参数 -d后台运行

docker run -p 3306:3306 --name mysql 
-v /usr/local/app/mysql/log:/var/log/mysql 
-v /usr/local/app/mysql/data:/var/lib/mysql 
-v /usr/local/app/mysql/conf:/etc/mysql 
-e MYSQL_ROOT_PASSWORD=root 
-d mysql:5.7

运行结果:

[root@localhost ~]# docker run -p 3306:3306 --name mysql 
> -v /usr/local/app/mysql/log:/var/log/mysql 
> -v /usr/local/app/mysql/data:/var/lib/mysql 
> -v /usr/local/app/mysql/conf:/etc/mysql 
> -e MYSQL_ROOT_PASSWORD=root 
> -d mysql:5.7
645dab4cb60caa19225dbc73660b969c15f5d45841e5222db738504a9f4bd169
[root@localhost ~]# docker ps
CONTAINER ID   IMAGE                  COMMAND                  CREATED         STATUS         PORTS                                            NAMES
645dab4cb60c   mysql:5.7              "docker-entrypoint.s…"   2 minutes ago   Up 2 minutes   0.0.0.0:3306->3306/tcp, 33060/tcp                mysql

MySQL用到的日志、配置、数据文件都会挂载到下面文件夹中

[root@localhost ~]# cd /usr/local/app/mysql
[root@localhost mysql]# ll
total 4
drwxr-xr-x. 2 root    root    6 Jan 24 12:57 conf
drwxr-xr-x. 5 polkitd root 4096 Jan 24 12:58 data
drwxr-xr-x. 2 root    root    6 Jan 24 12:57 log
[root@localhost mysql]# 
1.3、修改MySQL配置文件

进入/usr/local/app/mysql/conf,创建my.conf文件

[root@localhost mysql]# cd /usr/local/app/mysql/conf
[root@localhost conf]# ll
total 0
[root@localhost conf]# vi my.conf

复制下面内容到my.conf,保存退出

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve

然后重启mysql

[root@localhost conf]# docker restart mysql
mysql
[root@localhost conf]# docker ps
CONTAINER ID   IMAGE                  COMMAND                  CREATED          STATUS          PORTS                                            NAMES
645dab4cb60c   mysql:5.7              "docker-entrypoint.s…"   10 minutes ago   Up 7 seconds    0.0.0.0:3306->3306/tcp, 33060/tcp                mysql
1.4、设置MySQL自动启动
[root@localhost conf]# docker update mysql --restart=always
mysql
[root@localhost conf]# 

此时即可使用Navicat等连接工具连接MySQL了

Docker安装MySQL和Redis
MySQL.jpg

2、Docker安装Redis

2.1、创建Redis配置文件

mkdir -p表示递归创建目录。

[root@localhost /]# mkdir -p /usr/local/app/redis/conf
[root@localhost /]# cd /usr/local/app/redis/conf
[root@localhost conf]# vi redis.conf

在redis.conf中添加appendonly yes,开启持久化。

appendonly yes

然后保存退出

2.2、拉取Redis镜像
docker pull redis

启动Redis

docker run -p 6379:6379 --name redis 
-v /mydata/redis/data:/data 
-v /mydata/redis/conf/redis.conf:/etc/redis/redis.conf 
-d redis redis-server /etc/redis/redis.conf

设置Redis容器自动启动

docker update redis --restart=always
2.3、安装Redis客户端

官网下载地址:https://redisdesktop.com/pricing,但是官网下载需要付费,百度网盘下载:https://pan.baidu.com/s/1K5Yd1OQ8nAofCl79Hp8r1A,提取码:528k。
下载、安装完成以后,运行Redis Desktop Manager

Docker安装MySQL和Redis
redis1.png

点击Connect to Redis Server,然后输入IP、端口,有设置密码的话,输入密码。

Docker安装MySQL和Redis
redis3.jpg

连接成功。

Docker安装MySQL和Redis
redis4.jpg
© 版权声明

相关文章

暂无评论

暂无评论...