ubuntu+docker部署mysql

拉取mysql镜像

docker pull mysql

启动容器

docker run -itd --name mysql-test -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql

查看容器

docker ps -a

进入容器，2fce741d0d6f为容器id

docker exec -it 2fce741d0d6f bash

进入mysql

mysql -h localhost -u root -p

见到如下界面，密码是 123456

图片.png

修改密码：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';