Docker安装Mysql单机(为多节点准备)

Docker安装Mysql单机(为多节点准备)

#下载mysql
docker pull mysql

#创建文件夹
mkdir -p /root/docker/mysql-master/conf && mkdir -p /root/docker/mysql-master/data && mkdir -p /root/docker/mysql-master/log

#创建mysql服务
docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root -d mysql

#将mysql中的my.cnf复制到 /root/docker/mysql-master/conf 中
docker cp mysql:/etc/mysql/my.cnf /root/docker/mysql-master/conf

#停止并删除之前的mysql服务
docker rm -f mysql

#创建mysql-master服务
docker run \
 --name mysql-master \
 --privileged=true	\
 --restart=always \
 -p 13306:3306 \
 -v /root/docker/mysql-master/data:/var/lib/mysql \
 -v /root/docker/mysql-master/log:/var/log/mysql \
 -v /root/docker/mysql-master/conf/my.cnf:/etc/mysql/my.cnf:rw \
 -e MYSQL_ROOT_PASSWORD=Wei19970825 \
 -d mysql
 
 
#进入mysql-master容器
docker exec -it mysql-master /bin/bash
 
#进入mysql数据库
mysql -uroot -p
 
#输入mysql密码
#远程连接授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION; 

#刷新权限
FLUSH PRIVILEGES;

#更改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

#更新root用户密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Wei19970825'; 

#刷新权限
FLUSH PRIVILEGES;