Re: I use MySQL connectorl and after some time it stops. PLEASE HELP

[Chuck Bell]

Like this. Sorry, I said "disconnect" as in the action, not the method needed. Close is the method to disconnect.

void loop() {
Serial.println("Sleeping...");
delay(2000);
Serial.println("Connecting...");
if (conn.connect(server_addr, 3306, user, password)) {
delay(500);
Serial.println("Running a query");
cur.execute("SHOW DATABASES"); // execute a query
cur.show_results(); // show the results
cur.close(); // close the cursor
conn.close(); // close the connection
} else {
Serial.println("Connect failed. Trying again on next iteration.");
}
}