xxljob docker compose deploy: could not create connection to database server

docker-compose.yaml file

version: '2'services:  xxl-job:    container_name: xxl-job    image: xuxueli/xxl-job-admin:2.3.1    ports:      - 8080:8080    links:      - mysql    depends_on:      - mysql    environment:      PARAMS: '--spring.datasource.url=jdbc:mysql://mysql:3306/xxl_job?useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&serverTimezone=Asia/Shanghai --spring.datasource.username=root --spring.datasource.password=root --xxl.job.accessToken=dasj2nd81jf9asjdkl5jk234'    networks:      - xxl_job_net  mysql:    container_name: mysql    image: mysql    restart: always    ports:      - 13306:3306    volumes:      - .:/docker-entrypoint-initdb.d    command: --default-authentication-plugin=mysql_native_password    environment:      MYSQL_ROOT_PASSWORD: root      MYSQL_DATABASE: xxl_job    networks:      - xxl_job_netnetworks:  xxl_job_net:    driver: bridge

>>> docker compose up
Could not create connection to database server


解决方案:
1 查问docker mysql ip address

>>> docker inspect mysql | grep IPAddress# 172.18.0.2

2 替换docker-compose.yaml文件中 PARAMS spring.datasource.url值

--spring.datasource.url=jdbc:mysql://mysql:3306/xxl_job替换为--spring.datasource.url=jdbc:mysql://172.18.0.2:3306/xxl_job

3 docker compose up 连贯胜利