- docker pull mysql:latest
-
运行镜像 创建容器
- docker run -p 3306:3306 -e MYSQL_DATABASE=workdb -e MYSQL_ROOT_PASSWORD=123456 -d mysql:latest
-
其中 -e是指定环境变量,MYSQL_ROOT_PASSWORD 是 root 用户的登陆密码
docker exec -it 3e3b56425a02 bash
- mysql -u root -p
-
- alter user 'root'@localhost IDENTIFIED BY'123456';
-
- CREATE USER 'wkcto'@'%' IDENTIFIED WITH mysql_native_password BY '123456';GRANT ALL PRIVILEGES ON *.* TO 'wkcto'@%';
-