vim docker-compose-mysql-8.yaml

version: '3'
services:
  mysql:
    restart: always
    privileged: true
    image: mysql:8.0.39
    container_name: mysql-8
    command:
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
    environment:
      MYSQL_ROOT_HOST: '%'
      MYSQL_ROOT_PASSWORD: "12345678"
      MYSQL_USER: "huang"
      MYSQL_PASSWORD: "12345678"
      MYSQL_INITDB_SKIP_TZINFO: "Asia/Shanghai"
    volumes:
      - /srv/docker/mysql/data:/var/lib/mysql
      - /srv/docker/mysql/conf/my.cnf:/etc/my.cnf
    ports:
      - 3306:3306

# -d 后台运行
sudo docker compose -f ./docker-compose-mysql-8.yaml up -d

docker exec -it mysql-8 /bin/sh

docker cp mysql-8:/var/lib/mysql /srv/docker/mysql/data
docker cp mysql-8:/etc/my.cnf /srv/docker/mysql/conf

# 查看my.cnf配置位置的读取顺序
mysql --help | grep my.cnf 

# 连接数据库测试
 mysql -uroot -p12345678     # 密码 12345678
  mysql -uhuang -p     # 密码 12345678
#修改密码
mysqladmin -u用户名 -p旧密码 password 新密码
mysqladmin -u root -h '%'  -p --ssl-mode=required  password 7ow9PBz2sqEqYi