Docker安装和使用MySQL

一、拉取MySQL镜像

docker pull mysql:5.7.25

docker pull mysql:8.0.28

二、在宿主机创建 data 和 conf 目录

用于和容器内目录挂载

mkdir /home/local/mysql/data
mkdir /home/local/mysql/conf

二、运行容器

docker run -d \
  --name my-mysql \
  -e MYSQL_ROOT_PASSWORD=your_pwd\
  -v /home/local/mysql/data:/var/lib/mysql \
  -v /home/local/mysql/conf:/etc/mysql/conf.d \
  -p 3306:3306 \
  mysql:5.7.25

docker run -d \
  -p 3306:3306 \
  --restart unless-stopped \
  -v /opt/docker/mysql8/log:/var/log/mysql \
  -v /opt/docker/mysql8/data:/var/lib/mysql \
  -v /opt/docker/mysql8/conf:/etc/mysql \
  -v /opt/docker/mysql8/mysql-files:/var/lib/mysql-files \
  -e MYSQL_ROOT_PASSWORD=root666Jagochan888 \
  --name mysql8.0.28 \
  mysql:8.0.28

docker run -d \
  --name mysql \
  -p 3306:3306 \
  -e TZ=Asia/Shanghai \
  -e MYSQL_ROOT_PASSWORD=success\
  -v /opt/docker/mysql8/data:/var/lib/mysql \
  -v /opt/docker/mysql8/conf:/etc/mysql/conf.d \
  -v /opt/docker/mysql8/init:/docker-entrypoint-initdb.d \
  --network mall-net \
  mysql:8.0.28