After 2/20 conn.connector hangs on "....trying"

[IdeaKing]

Hi, I have been using the following pieces of code:

  // Connect to MySQL
  if (conn.connect(server_addr, 3306, user, pass, db)) {
    delay(1000);
  } else {
    Serial.println("Connection failed.");
  }

The code was working fine until 2 days ago, now the ESP32 hangs on "....trying" and is unable to connect to the MySQL server. Any help would be greatly appreciated!

[ChuckBell]

The first thing to do is figure out what changed. Consider everything: networking, user account, firewall, software upgrades to Arduino ide, etc. Once you find potential sources, I may be able to suggest something more concrete.On Feb 22, 2024, at 7:16 PM, Thomas Chia ***@***.***> wrote: Hi, I have been using the following pieces of code: // Connect to MySQL if (conn.connect(server_addr, 3306, user, pass, db)) { delay(1000); } else { Serial.println("Connection failed."); } The code was working fine until 2 days ago, now the ESP32 hangs on "....trying" and is unable to connect to the MySQL server. Any help would be greatly appreciated! —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[ChuckBell]

Another possibility is the database you’ve specified doesn’t exist. The connector is very lightweight and thus does not report extensive errors. You will need to debug it first.

…

On Feb 22, 2024, at 7:16 PM, Thomas Chia ***@***.***> wrote: Hi, I have been using the following pieces of code: // Connect to MySQL if (conn.connect(server_addr, 3306, user, pass, db)) { delay(1000); } else { Serial.println("Connection failed."); } The code was working fine until 2 days ago, now the ESP32 hangs on "....trying" and is unable to connect to the MySQL server. Any help would be greatly appreciated! — Reply to this email directly, view it on GitHub <#222>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB6SHYDQFQMPZAVLTTC3FVTYU7NWBAVCNFSM6AAAAABDV3YG3WVHI2DSMVQWIX3LMV43ASLTON2WKOZSGE2TAMJVG42TSMY>. You are receiving this because you are subscribed to this thread.