sql+如何连接云服务器配置

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查询
    cursor.execute("SELECT * FROM your_table_name")
    
    # 获取查询结果
    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("数据库连接已关闭")