ChuckBell
commented
3 years ago What version of MySQL are you using? What version of the connector?
On Thu, Jun 3, 2021 at 08:59 TETONJoshua @.***> wrote:
Hello, I'm trying to set up an esp32 to write data to a microsoft azure database, but I'm having a problem connecting to the database. I end up with the following unreadable error: Error: 44 = tive_passwordm�+�S3�dX�eu]sF\�y7F. I specify that the connection information is correct (password, ip, user) and that the error appears when executing the following command : conn.connect(server_addr, 3306, user, password). thank you in advance if you can help me.
Used code :
include
include
include
IPAddress server_addr(); char user[] = ""; char password[] = "";
char INSERT_SQL[] = "INSERT INTO Totems (IdTotem, Lieux) VALUES (3, 'Tomblaine')"; char ssid[] = ""; char pass[] = "";
WiFiClient client; MySQL_Connection conn(&client); MySQL_Cursor* cursor;
void setup()
{ Serial.begin(115200); while (!Serial); Serial.printf("\nConnecting to %s", ssid); WiFi.mode(WIFI_STA); WiFi.begin(ssid, pass); while (WiFi.status() != WL_CONNECTED) { delay(500); Serial.print("."); }
Serial.println("\nConnected to network"); Serial.print("My IP address is: "); Serial.println(WiFi.localIP());
Serial.print("Connecting to SQL... "); if (conn.connect(server_addr, 3306, user, password)){ Serial.println("OK."); } else{ delay(2000); Serial.println("FAILED."); } cursor = new MySQL_Cursor(&conn); if (conn.connected()){ cursor->execute(INSERT_SQL); } delay(5000); WiFi.disconnect(); WiFi.mode(WIFI_OFF); }
void loop()
{
}
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/172, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYCRST75AJXDOYGK2UTTQ54CTANCNFSM46AXMCJQ .
TETONJoshua
Bjorn-J
Hello, I'm trying to set up an esp32 to write data to a microsoft azure database, but I'm having a problem connecting to the database. I end up with the following unreadable error: Error: 44 = tive_passwordm+S3dXeu]sF\y7F. I specify that the connection information is correct (password, ip, user) and that the error appears when executing the following command : conn.connect(server_addr, 3306, user, password). thank you in advance if you can help me.
Used code :
include
include
include
IPAddress server_addr(); char user[] = ""; char password[] = "";
char INSERT_SQL[] = "INSERT INTO Totems (IdTotem, Lieux) VALUES (3, 'Tomblaine')"; char ssid[] = ""; char pass[] = "";
WiFiClient client; MySQL_Connection conn(&client); MySQL_Cursor* cursor;
void setup()
{ Serial.begin(115200); while (!Serial); Serial.printf("\nConnecting to %s", ssid); WiFi.mode(WIFI_STA); WiFi.begin(ssid, pass); while (WiFi.status() != WL_CONNECTED) { delay(500); Serial.print("."); }
Serial.println("\nConnected to network"); Serial.print("My IP address is: "); Serial.println(WiFi.localIP());
Serial.print("Connecting to SQL... "); if (conn.connect(server_addr, 3306, user, password)){ Serial.println("OK."); } else{ delay(2000); Serial.println("FAILED."); } cursor = new MySQL_Cursor(&conn); if (conn.connected()){ cursor->execute(INSERT_SQL); } delay(5000); WiFi.disconnect(); WiFi.mode(WIFI_OFF); }
void loop()
{
}