Connect with MariaDB Connector/C

MariaDB Connector/C enables C and C++ applications to establish client connections to MariaDB Enterprise over TLS.

Additional information on MariaDB Connector/C is available in the MariaDB Knowledge Base.

Code Example: Connect

The following code demonstrates how to use MariaDB Connector/C to connect to MariaDB Enterprise. This example uses the example database and user account:

#include <stdio.h>
#include <stdlib.h>
#include <mysql.h>

int main (int argc, char* argv[])
{

   /* Initialize Connection */
   MYSQL *conn;
   if (!(conn = mysql_init(0)))
   {
      fprintf(stderr, "unable to initialize connection struct\n");
      exit(1);
   }

   /* Connect to MariaDB Enterprise */
   if (!mysql_real_connect(
         conn,                 /* Connection */
         "mariadb.example.net",/* Host */
         "db_user",            /* User account */
         "db_user_password",   /* User password */
         "test",               /* Default database */
         3306,                 /* Port number */
         NULL,                 /* Path to socket file */
         0                     /* Additional options */
      ))
   {

      /* Report Error, Close Connection, and Exit if connection fails */
      fprintf(stderr, "Error connecting to Server: %s\n", mysql_error(conn));
      mysql_close(conn);
      exit(1);
   }

   // Use the Connection
   // ...

   // Close the Connection
   mysql_close(conn);

   return 0;
}