连接网站怎么连接数据库

import pymysql

# 数据库连接参数
db_config = {
    'host': 'localhost',
    'port': 3306,
    'user': 'root',
    'password': 'your_password',
    'database': 'your_database'
}

# 创建连接
connection = pymysql.connect(**db_config)

try:
    # 创建游标对象
    with connection.cursor() as cursor:
        # 执行 SQL 查询
        sql = "SELECT * FROM your_table"
        cursor.execute(sql)
        result = cursor.fetchall()
        print(result)
finally:
    # 关闭连接
    connection.close()