Google Cloud SQL - Python Flask连接问题

from flask import Flask
import pymysql

app = Flask(__name__)

def get_db_connection():
    conn = pymysql.connect(
        host='your-cloud-sql-host',
        user='your-username',
        password='your-password',
        db='your-database',
        charset='utf8mb4',
        cursorclass=pymysql.cursors.DictCursor
    )
    return conn

@app.route('/')
def index():
    conn = get_db_connection()
    try:
        with conn.cursor() as cursor:
            sql = "SELECT * FROM your_table"
            cursor.execute(sql)
            result = cursor.fetchall()
            return str(result)
    finally:
        conn.close()

if __name__ == '__main__':
    app.run(host='0.0.0.0', port=8080)

import os
from google.cloud import sql.connector

def get_db_connection():
    db_user = os.getenv('DB_USER')
    db_pass = os.getenv('DB_PASS')
    db_name = os.getenv('DB_NAME')
    db_host = os.getenv('DB_HOST')

    conn = sql.connector.connect(
        user=db_user,
        password=db_pass,
        database=db_name,
        host=db_host
    )
    return conn

import pymysql

def get_db_connection():
    conn = pymysql.connect(
        host='your-cloud-sql-host',
        user='your-username',
        password='your-password',
        db='your-database',
        ssl={'ca': '/path/to/server-ca.pem'}
    )
    return conn