docker拉取mysql镜像并启动

1.安装Docker的依赖库

yum install -y yum-utils device-mapper-persistent-data lvm2

2.添加Docker CE的软件源信息

yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo

3.安装Docker CE

yum makecache fast
yum -y install docker-ce

4.  启动Docker服务

systemctl start docker

5.使用阿里云镜像仓库

sudo mkdir -p /etc/docker
sudo tee /etc/docker/daemon.json <<-'EOF'
{
  "registry-mirrors": ["https://********.mirror.aliyuncs.com"]
}
EOF

6.重启docker

sudo systemctl daemon-reload
sudo systemctl restart docker

7.拉取mysql镜像

docker search mysql

docker pull mysql:latest

8.查看下载镜像

docker images 查看已有镜像
docker ps -a 查看容器
docker ps -s 查看启动容器
docker container rm d50398bd7b43 删除容器
docker container ls -a 列举容器

9.启动mysql镜像

docker run \
--restart=always \
--name mysql-service \
-v /mysql/data:/var/lib/mysql \
-p 3306:3306 \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql \
--character-set-server=utf8mb4 \
--collation-server=utf8mb4_general_ci \
--lower_case_table_names=1 \
--skip-name-resolve=1 \
--max_connections=1000 \
--wait_timeout=31536000 \
--interactive_timeout=31536000 \
--default-time-zone='+8:00'

10.进入mysql容器

docker exec -it mysql-service sh

11.创建用户、授权用户等操作

// mysql create user 创建用户
create user 'test'@'%' identified with MYSQL_NATIVE_PASSWORD by 'xxss45mysql8 ';
// grant privileges 授权
GRANT SELECT,ALTER,UPDATE,CREATE,INSERT,DELETE,CREATE TEMPORARY TABLES,DROP,INDEX,REFERENCES,TRIGGER,ALTER ROUTINE,CREATE ROUTINE,CREATE TABLESPACE,CREATE TEMPORARY TABLES,CREATE VIEW,EVENT,EXECUTE,PROCESS,RELOAD,SHOW DATABASES,SHOW VIEW,TRIGGER ON *.* TO 'test'@'%';

12.运行nginx

docker run --name nginx-service -p 80:80 -d nginx