1,安装支持rancher 的docker,方便后期做集群管理
curl https://releases.rancher.com/install-docker/18.09.sh | sh
安装成功后创建docker自定义网络,方便容器间互通
docker network create --driver bridge --subnet 192.168.0.0/16 --gateway 192.168.0.1 mynet
2,docker安装mysql,指定上面创建的mynet自定义网络(–network mynet)映射本地目录
docker run -p 3306:3306 --network mynet --name mysql \
-v /usr/local/docker/mysql/conf:/etc/mysql \
-v /usr/local/docker/mysql/logs:/var/log/mysql \
-v /usr/local/docker/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7
3,测试mysql链接
docker exec -it mysql bash #进入容器
mysql -uroot -p123456 #登录mysql
4,添加用户并授权(root登录mysql控制台执行)
- 添加用户
create user ljbb identified by 'ljbb@123';
# create user 账号 identified by '密码';
- 授权,刷新
grant all privileges on lijia_ehr.* to ljbb@'localhost' identified by 'ljbb@123'; #授权
flush privileges; #刷新
show grants for 'ljbb'; #查看授权
- 退出后用新建用户测试登录是否成功