mysql 客户端超时时间

import mysql.connector

# 创建数据库连接
config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database',
    'raise_on_warnings': True,
    'connect_timeout': 10  # 连接超时时间（秒）
}

try:
    cnx = mysql.connector.connect(**config)
    cursor = cnx.cursor()

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

    # 设置查询超时时间（秒）
    cursor.set_session(sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION")
    cursor.execute(query, timeout=5)

    # 处理查询结果
    for row in cursor:
        print(row)

except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    cursor.close()
    cnx.close()