dockermysql配置详解（Docker 部署Mysql 服务和Redis 服务的方法）

mkdir -p /home/computer/project/mysql/{conf,log,data}

duso docker run -p 53603:3306 --name iot-mysql \ -v /home/computer/project/mysql/conf:/etc/mysql \ -v /home/computer/project/mysql/log:/var/log/mysql \ -v /home/computer/project/mysql/data:/var/lib/mysql \ -e MYSQL_ROOT_PASSWORD=pwd \ -d mysql:5.6

# 容器内操作
mysql -uroot -p123456
mysql> grant all privileges on *.* to root@'%' identified by "password";
select host,user,password from user;

# 修改密码
update user set password=password("xxxxx") where user="root";
flush privileges;

sudo docker run -itd --name redis1 -p 53610:6379 redis --requirepass "psd"

sudo docker run -itd --name redis1 -p 53610:6379 -v /home/computer/project/redis/data:/data --restart always redis --appendonly yes --requirepass "psd"

-d         -> 以守护进程的方式启动容器
-p 53610:6379      -> 绑定宿主机端口，53610宿主机端口，6379 容器端口
--name myredis      -> 指定容器名称
--restart always     -> 开机启动
--privileged=true     -> 提升容器内权限
--requirepass      -> 设置登录密码
-v /root/docker/redis/data:/data -> 映射数据目录
--appendonly yes     -> 开启数据持久化