docker pull mysql (拉取镜像)
docker run --name mysql -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD="123"(-e MYSQL_USER="root" -e MYSQL_PASSWORD="123")mysql (运行镜像)
docker ps (查看所有正在运行的容器)
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
139f4ebbb37e mysql "docker-entrypoint.s…" 6 seconds ago Up 5 seconds 0.0.0.0:3306->3306/tcp, :::3306->3306/tc competent_noether
1fae6fd93142 redis "docker-entrypoint.s…" 14 hours ago Up 8 minutes 0.0.0.0:6379->6379/tcp, :::6379->6379/tcp serene_swartz
832e07265091 tomcat "/usr/local/apache-t…" 17 hours ago Up 8 minutes 0.0.0.0:8080->8080/tcp, :::8080->8080/tcp infallible_mcnulty
docker exec -it 139f4ebbb37e(容器id) /bin/bash (进入容器)
mysql -uroot -p123 (登陆mysql)
如果需要远程登录的(远程连接用密码123),需要执行授权命令:
GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL PRIVILEGES on *.* TO root@'%' WITH GRANT OPTION;
ALTER USER 'root'@'%' IDENTIFIED BY '123' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';
FLUSH PRIVILEGES;