如何使用pymsql在docker容器上连接到mariadb

version: '3'
services:
  mariadb:
    image: mariadb
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: your_password
    volumes:
      - ./data:/var/lib/mysql
  python:
    build:
      context: .
      dockerfile: Dockerfile
    volumes:
      - ./app:/app
    depends_on:
      - mariadb

FROM python:3.9
WORKDIR /app
COPY requirements.txt .
RUN pip install --no-cache-dir -r requirements.txt
COPY . .
CMD ["python", "your_script.py"]

pymysql

import pymysql

# 连接到mariadb数据库
conn = pymysql.connect(
    host='mariadb',
    user='root',
    password='your_password',
    db='your_database',
    charset='utf8mb4',
    cursorclass=pymysql.cursors.DictCursor
)

# 执行SQL查询
try:
    with conn.cursor() as cursor:
        # 执行SQL语句
        sql = 'SELECT * FROM your_table'
        cursor.execute(sql)
        result = cursor.fetchall()
        print(result)
finally:
    conn.close()

docker-compose up -d

docker-compose logs -f