异常出现步骤
1、应用启动有分配虚拟IP,如以下docker-compose.yml配置
version: '3'
services:
mysql:
image: mysql:8.0.27
container_name: mysql
environment:
# 时区上海
TZ: Asia/Shanghai
# root 密码
MYSQL_ROOT_PASSWORD: Pass@123
# 初始化数据库
MYSQL_DATABASE: base-db
ports:
- "3306:3306"
volumes:
# 数据挂载
- /docker/mysql/data/:/var/lib/mysql/
# 配置挂载
- /docker/mysql/conf/:/etc/mysql/conf.d/
command:
# 将mysql8.0默认密码策略 修改为 原先 策略 (mysql8.0对其默认策略做了更改 会导致密码无法匹配)
--default-authentication-plugin=mysql_native_password
--character-set-server=utf8mb4
--collation-server=utf8mb4_general_ci
--explicit_defaults_for_timestamp=true
--lower_case_table_names=1
privileged: true
restart: always
networks:
docker_net:
ipv4_address: 172.33.0.36
networks:
docker_net:
driver: bridge
ipam:
config:
- subnet: 172.33.0.0/16
2、在docker启动mysql时,防火墙处于关闭状态
3、停止mysql
4、再启动mysql,就会出现异常
解决方法
重启docker
service docker restart