如何基于docker安装mysql 5.7

• 创建配置目录

sudo mkdir -p /data/docker/mysql-5.7/etc

• 创建数据存储目录

sudo mkdir -p /data/docker/mysql-5.7/var

• 临时启动一个实例

docker run  --detach \
--restart always \
--name mysql-5.7 \
--publish 13306:3306 \
--volume /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime \
--env MYSQL_ROOT_PASSWORD=Gah6kuP7ohfio4 \
mysql:5.7.28

• 复制原始配置到宿主机

sudo docker cp mysql-5.7:/etc/mysql/conf.d /data/docker/mysql-5.7/etc/conf.d

sudo docker cp mysql-5.7:/etc/mysql/mysql.conf.d /data/docker/mysql-5.7/etc/mysql.conf.d

• 移除该实例

docker stop mysql-5.7

docker rm mysql-5.7

• 重新正式开启一个实例

docker run  --detach \
--restart always \
--name mysql-5.7 \
--publish 13306:3306 \
--volume /data/docker/mysql-5.7/var:/var/lib/mysql \
--volume /data/docker/mysql-5.7/etc/conf.d:/etc/mysql/conf.d \
--volume /data/docker/mysql-5.7/etc/mysql.conf.d:/etc/mysql/mysql.conf.d \
--volume /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime \
--env MYSQL_ROOT_PASSWORD=Gah6kuP7ohfio4 \
mysql:5.7.28

• 查看实例

lwk@qwfys:~$ docker ps -a
CONTAINER ID   IMAGE                      COMMAND                  CREATED          STATUS                     PORTS                                                                      NAMES
4b97666b6afb   mysql:5.7.28               "docker-entrypoint.s…"   34 minutes ago   Up 34 minutes              33060/tcp, 0.0.0.0:13306->3306/tcp, :::13306->3306/tcp                     mysql-5.7

lwk@qwfys:~$ 

• 访问实例

spring:
  datasource:
    hikari:
      jdbc-url: jdbc:mysql://127.0.01:13306/mysql?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=Asia/Shanghai
      username: root
      password: Gah6kuP7ohfio4

• 停用实例

docker stop mysql-5.7

• 删除实例

docker rm mysql-5.7