11 years, 8 months ago.  This question has been closed. Reason: resolved the issue

Connecting mbed to MySQL data base

Hi All,

I’m a newbie to the mbed network and I’m currently trying to connect my mbed board to a MySQL data base using the MySQLClientExample that is in the cookbook. My goal is to upload data from several different sensors but right now I can’t even manage to get the MySQLClientExample working. I’m getting the error “Error 5 during connection” Is there anyone that could help me out? I have tried numerous different sequences for the connection. It’s a remote host server that the MySQL data base is on. Here is the code that I’m trying to use.

Kind regards, Jason

#define SQL_SERVER   "78.xxx.xxx.92"
#define SQL_USER     "project"
#define SQL_PASSWORD "atxxxxxx08"
#define SQL_DB       "Test"

EthernetNetIf eth; 
MySQLClient sql;

MySQLResult sqlLastResult;
void onMySQLResult(MySQLResult r)
{
  sqlLastResult = r;
}

int main()
{
  printf("Start\n");

  printf("Setting up...\n");
  EthernetErr ethErr = eth.setup();
  if(ethErr)
  {
    printf("Error %d in setup.\n", ethErr);
    return -1;
  }
  printf("Setup OK\n");

  
  Host host(IpAddr(), 3306, SQL_SERVER);
  
  //Connect
  sqlLastResult = sql.open(host, SQL_USER, SQL_PASSWORD, SQL_DB, onMySQLResult);

etc............................