import mysql.connector
try:
# Establish a connection to the MySQL server
connection = mysql.connector.connect(
host="<your_mysql_host>",
user="<your_mysql_username>",
password="<your_mysql_password>",
database="<your_mysql_database>"
)
# Execute your query here, e.g., using a cursor
cursor = connection.cursor()
cursor.execute("<your_mysql_query>")
# Fetch the results if required
results = cursor.fetchall()
for row in results:
print(row)
# Close the cursor and connection
cursor.close()
connection.close()
except mysql.connector.Error as error:
# Handle the lost connection error
if error.errno == 2013:
print("Lost connection to MySQL server during query!")
else:
print("An error occurred:", error)