docker安装mysql8一、准备工作(1)安装dockerdocker-compse(2)创建相关目录#创建home目录下mysql文件夹和mysql里的conf,data,log三个文件mkdir-p/data/mysql/{conf,data,log}# 赋予 conf 目录读和写的权限 (rwxr-xr-x)chmod755/data/mysql/confchmod755/data/mysql/datachmod755/data/mysql/log#创建配置文件touch/data/mysql/conf/my.cnf进入my.cof编写配置[mysqld]# -------------------- 远程连接 --------------------# 默认密码插件兼容旧版本的客户端default_authentication_pluginmysql_native_password# authentication_policymysql_native_password,caching_sha2_password# -------------------- 字符集与排序规则 --------------------# 服务器默认字符集MySQL 8 强烈建议 utf8mb4character-set-serverutf8mb4# 默认排序规则utf8mb4_unicode_ci 或 utf8mb4_general_ci前者更精确collation-serverutf8mb4_unicode_ci# 客户端连接时默认字符集兼容旧客户端init-connectSET NAMES utf8mb4# -------------------- 时区设置 --------------------# 默认时区中国为 8:00default-time-zone8:00二、运行mysql1直接运行dockerrun-d\--namemysql8\--restartalways\-p3306:3306\-eMYSQL_ROOT_PASSWORDyour_root_password\-eTZAsia/Shanghai\-v/data/mysql/conf/my.cnf:/etc/mysql/my.cnf:ro\-v/data/mysql/data:/var/lib/mysql\-v/data/mysql/log:/var/log/mysql\mysql:8.0.36-d 后台运行–name mysql8 容器名称–restartalways 容器异常退出自动重启-p 3306:3306 映射端口宿主机:容器-e MYSQL_ROOT_PASSWORDxxx 必须设置root 密码-e TZAsia/Shanghai 设置容器时区-v /data/mysql/conf/my.cnf:/etc/mysql/my.cnf:ro 挂载配置文件:ro 只读-v /data/mysql/data:/var/lib/mysql 挂载数据目录持久化-v /data/mysql/log:/var/log/mysql 挂载日志目录持久化mysql:8.0.36 指定版本号2使用docker compos运行创建目录mkdir-p/compose/envtouch/compose/env/compose.yaml进入/compose/env/compose.yaml编写services: mysql: image: mysql:8.0.36 container_name: mysql restart: always ports: -3306:3306environment: MYSQL_ROOT_PASSWORD: your_root_password TZ: Asia/Shanghai volumes: - /data/mysql/conf/my.cnf:/etc/mysql/my.cnf:ro - /data/mysql/data:/var/lib/mysql - /data/mysql/log:/var/log/mysql启动#进入目录cd/compose/env#启动dockercompose up-d