使用python连接google- Cloud -platform mysql服务，查询云SQL管理API

pip install mysql-connector-python google-auth google-api-python-client

export GOOGLE_APPLICATION_CREDENTIALS="/path/to/your/service-account-file.json"

import mysql.connector

# 连接到MySQL实例
config = {
    'user': 'your-username',
    'password': 'your-password',
    'host': 'your-instance-ip',
    'database': 'your-database-name',
    'raise_on_warnings': True
}

connection = mysql.connector.connect(**config)
cursor = connection.cursor()

# 执行查询
query = "SELECT * FROM your_table_name"
cursor.execute(query)

# 打印结果
for (column1, column2) in cursor:
    print(f"{column1}, {column2}")

cursor.close()
connection.close()

from googleapiclient.discovery import build
from google.oauth2 import service_account

# 认证和构建服务
credentials = service_account.Credentials.from_service_account_file(
    '/path/to/your/service-account-file.json'
)
service = build('sqladmin', 'v1beta4', credentials=credentials)

# 列出所有实例
project_id = 'your-project-id'
request = service.instances().list(project=project_id)
response = request.execute()

# 打印实例名称
for instance in response['items']:
    print(instance['name'])