Lost connection to MySQL server during query - 如何解决MySQL报错：查询过程中与MySQL服务器断开连接

import mysql.connector

config = {
    'user': 'your_username',
    'passWord': 'your_password',
    'host': 'localhost',
    'database': 'your_database',
    'connection_timeout': 60
}

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

import mysql.connector

config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'localhost',
    'database': 'your_database',
}

# 尝试连接数据库
try:
    conn = mysql.connector.connect(**config)
    cursor = conn.cursor()
    # 执行查询操作
    query = "SELECT * FROM your_table"
    cursor.execute(query)
    # 获取查询结果
    result = cursor.fetchall()
except mysql.connector.Error as error:
    # 连接被断开，重新连接
    if error.errno == mysql.connector.errorcode.CR_SERVER_LOST:
        conn = mysql.connector.connect(**config)
        cursor = conn.cursor()
        # 重新执行查询操作
        cursor.execute(query)
        result = cursor.fetchall()
    else:
        # 处理其他错误
        print("Error: {}".fORMat(error))