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

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

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

pip install mysql-connector-python 

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

import mysql.connector from mysql.connector import Error import time  def 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 connection  def 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 iteration  if __name__ == "__main__":     main() 

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

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