MySQL连接断开后如何自动重连

要实现MySQL连接断开后的自动重连，您可以使用编程语言（如Python、Java等）来实现。这里我将为您提供一个Python示例，展示如何在连接断开后自动重新连接到MySQL数据库。

首先，确保已安装mysql-connector-python库。如果尚未安装，请使用以下命令进行安装：

pip install mysql-connector-python

接下来，创建一个Python脚本并添加以下代码：

import mysql.connectorfrom mysql.connector import Errorimport timedef create_connection():    connection = None    try:        connection = mysql.connector.connect(            host="your_host",            user="your_user",            password="your_password",            database="your_database"        )        print("Connection to MySQL DB successful")    except Error as e:        print(f"The error '{e}' occurred")    return connectiondef execute_query(connection, query):    cursor = connection.cursor()    try:        cursor.execute(query)        connection.commit()        print("Query executed successfully")    except Error as e:        print(f"The error '{e}' occurred")def main():    connection = create_connection()    while True:        if not connection.is_connected():            print("Connection lost, reconnecting...")            connection = create_connection()        else:            # Replace this with your own query            query = "SELECT * FROM your_table"            execute_query(connection, query)        time.sleep(5)  # Wait for 5 seconds before the next iterationif __name__ == "__main__":    main()

请确保将your_host、your_user、your_password和your_database替换为您的MySQL数据库的实际凭据。此外，根据需要更改your_table和查询。

这个脚本会每隔5秒执行一次查询。如果连接断开，它会尝试重新连接。如果连接成功，它将继续执行查询。您可以根据需要调整时间间隔和查询。