search

ChuckBell / MySQL_Connector_Arduino

Database connector library for using MySQL with your Arduino projects.
332 stars 133 forks source link

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

Open IdeaKing opened 7 months ago

IdeaKing commented 7 months ago

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 commented 7 months ago

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 commented 7 months ago

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 https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/222, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB6SHYDQFQMPZAVLTTC3FVTYU7NWBAVCNFSM6AAAAABDV3YG3WVHI2DSMVQWIX3LMV43ASLTON2WKOZSGE2TAMJVG42TSMY. You are receiving this because you are subscribed to this thread.