Docker 部署 MySQL 服务

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
# docker 中下载 mysql
docker pull mysql
 
#启动
docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql
 
#进入容器
docker exec -it mysql bash
 
#登录mysql
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456 ';
 
#添加远程登录用户
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';