python 远程mysql

SET GLOBAL wait_timeout = 28800;
SET GLOBAL interactive_timeout = 28800;

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

import mysql.connector

config = {
    'user': 'username',
    'password': 'password',
    'host': 'remote_host',
    'database': 'database_name',
    'ssl_ca': '/path/to/ca.pem',
    'ssl_cert': '/path/to/client-cert.pem',
    'ssl_key': '/path/to/client-key.pem'
}

cnx = mysql.connector.connect(**config)

import mysql.connector

# 配置连接参数
config = {
    'user': 'username',
    'password': 'password',
    'host': 'remote_host',
    'database': 'database_name'
}

try:
    # 建立连接
    cnx = mysql.connector.connect(**config)
    cursor = cnx.cursor()

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

    # 获取结果
    for row in cursor:
        print(row)

except mysql.connector.Error as err:
    print(f"Error: {err}")

finally:
    # 关闭连接
    if cnx.is_connected():
        cursor.close()
        cnx.close()