一、拉取mysql8.0镜像 
docker pull swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/wechatpadpro/mysql:8.0
docker tag  swr.cn-north-4.myhuaweicloud.com/ddn-k8s/docker.io/wechatpadpro/mysql:8.0  mysql:8.0
二、创建目录与配置文件
mkdir -p ~/mysql/{data,conf}
vi ~/mysql/conf/my.cnf

my.cnf的内容如下

[mysqld]
default-authentication-plugin=mysql_native_password
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
default-time-zone='+8:00'
innodb_buffer_pool_size=512M
max_connections=300

三、编写docker-compose.yml文件

version: "3.8"
services:
  mysql8:
    image: mysql:8.0          # 自动拉取官方 8.0 最新版
    container_name: mysql80
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: StrongRootPass!
      MYSQL_DATABASE: along
      MYSQL_USER: root
      MYSQL_PASSWORD: along@12345
    ports:
      - "3309:3306"
    volumes:
      - ~/mysql/data:/var/lib/mysql
      - ~/mysql/conf:/etc/mysql/conf.d
    command: --default-authentication-plugin=mysql_native_password
四、启动

cd ~/mysql
docker-compose up --build -d # 后台拉取并运行
docker ps # 看到 mysql80 容器 Up 即成功
五、客户端连接测试

本地测试
mysql -h127.0.0.1 -uroot -pStrongRootPass!

    六、常用命令

docker-compose stop | start | restart
docker logs mysql80  -fn500           # 看日志
docker exec -it mysql80 bash          # 进容器

docker exec -it mysql80  mysql -h127.0.0.1 -uroot -pStrongRootPass!