Docker 部署 MySQL 服务#

1
# docker 中下载 mysql
2
docker pull mysql
3

4
#启动
5
docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql
6

7
#进入容器
8
docker exec -it mysql bash
9

10
#登录mysql
11
mysql -u root -p
12
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456 ';
13

14
#添加远程登录用户
15
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
16
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';