version: '3.3'
services:
mysql-app:
image: 'mysql:8.0'
container_name: 'mysql'
restart: always
ports:
- '3306:3306'
environment:
MYSQL_ROOT_PASSWORD: 'UDYB3nMs' # root用户的密码
MYSQL_ROOT_HOST: '%' # 访问权限
# MYSQL_USER: test # 创建新用户
# MYSQL_PASSWORD: test # 新用户的密码
volumes:
- '/etc/localtime:/etc/localtime:ro' #同步宿主机日期时间到容器
- '/opt/app/mysql/data:/var/lib/mysql'
- '/opt/app/mysql/conf:/etc/mysql/conf.d'
- '/opt/app/mysql/logs:/logs'
command:
# default-authentication-plugin=mysql_native_password mysql5为mysql_native_password, 支持较好, mysql8为默认为caching_sha2_password, 部分旧软件不支持;
# character-set-server=utf8mb4 默认创建新数据的新建字符集
# collation-server=utf8mb4_general_ci 默认创建新数据的新建排序规则
# default-time-zone='+8:00' 选择正8区
# max_connections=1000 设置最大连接数
# innodb_lock_wait_timeout=500 innodb的dml操作的行级锁的等待时间
--default-authentication-plugin=mysql_native_password
--character-set-server=utf8mb4
--lower_case_table_names=1
--collation-server=utf8mb4_general_ci
--default-time-zone='+8:00'
--max_connections=1000
--innodb_lock_wait_timeout=500
docker-compose.yml mysql8.0文件
于 2022-10-24 08:57:32 首次发布