Docker-compose检查mysql连接是否就绪[版本3]

version: '3'
services:
  mysql:
    image: mysql:latest
    environment:
      MYSQL_ROOT_PASSWORD: password
    ports:
      - 3306:3306
    networks:
      - mynetwork

  your_service:
    build:
      context: .
      dockerfile: Dockerfile
    depends_on:
      - mysql
    networks:
      - mynetwork

networks:
  mynetwork:

import mysql.connector
from time import sleep

def check_mysql_connection():
    while True:
        try:
            conn = mysql.connector.connect(
                host='mysql',
                user='root',
                password='password',
                database='your_database'
            )
            conn.close()
            print("MySQL connection is ready!")
            break
        except mysql.connector.Error as err:
            print("MySQL connection error:", err)
            sleep(1)

check_mysql_connection()

FROM python:3.9

WORKDIR /app

COPY requirements.txt .
RUN pip install --no-cache-dir -r requirements.txt

COPY . .

CMD ["python", "your_script.py"]

docker-compose up