如何连接云服务器的数据库

import mysql.connector

# 数据库连接配置
config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'your_server_ip',
    'database': 'your_database_name',
    'port': 'your_port_number'
}

try:
    # 连接到数据库
    connection = mysql.connector.connect(**config)
    print("成功连接到数据库")

    # 创建游标对象
    cursor = connection.cursor()

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

    # 获取查询结果
    results = cursor.fetchall()
    for row in results:
        print(row)

except mysql.connector.Error as err:
    print(f"连接失败: {err}")
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("数据库连接已关闭")