Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

I'm trying to connect to a MariaDB database in a C script and I can't find the necessary documentation. I installed libmariadbclient-dev, but I couldn't find any accompanying documentation such as a man page. There's a basic description and limited documentation here , but the documentation only includes descriptions of functions. The fact is, despite having scoured all sorts of Google results, I don't even know what to import to get this to work, much less how to use it. Is there any guide or documentation on how to use a MariaDB database in C?

The MariaDB Client Library for C has exactly the same API as the MySQL Connector/C for MySQL 5.5

Here it is: http://dev.mysql.com/doc/refman/5.5/en/c-api-function-overview.html

Another one: http://zetcode.com/db/mysqlc/

You can compile a minimal test like

#include <my_global.h>
#include <mysql.h>
int main(int argc, char **argv)
  MYSQL *con = mysql_init(NULL);
  if (con == NULL) 
      fprintf(stderr, "%s\n", mysql_error(con));
      exit(1);
  if (mysql_real_connect(con, "localhost", "root", "root_pswd", 
          NULL, 0, NULL, 0) == NULL) 
      fprintf(stderr, "%s\n", mysql_error(con));
      mysql_close(con);
      exit(1);
  if (mysql_query(con, "CREATE DATABASE testdb")) 
      fprintf(stderr, "%s\n", mysql_error(con));
      mysql_close(con);
      exit(1);
  mysql_close(con);
  exit(0);
using
gcc -o mysql-test mysql-test.c $(mysql_config --libs)
                @DonNisnoni MySQL is also open source (although also available as non-open source).  I highly recommend reading on the story of those two databases and how the fork happened.
– jlh
                Jan 2, 2022 at 15:48
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.