Connect with MySQL using C in ubuntu

It is possible to connect with MySQL using C. Here I am directing a way for that.

First of all you need

• mysql server(sudo apt-get install mysql-server)
  
• A library for developers(libmysqlclient-dev)

Now we write a code to connect with mysql and which shows all the tables in database

Code:

/* Simple C program that connects to MySQL Database server*/
#include <mysql.h>
#include <stdio.h>

main() {
  MYSQL *conn;
  MYSQL_RES *res;
  MYSQL_ROW row;

  char *server = "localhost";
  char *user = "root";
  //set the password for mysql server here
  char *password = ""; /* set me first */
  char *database = "mysql";

  conn = mysql_init(NULL);

  /* Connect to database */
  if (!mysql_real_connect(conn, server,
        user, password, database, 0, NULL, 0)) {
      fprintf(stderr, "%s\n", mysql_error(conn));
      exit(1);
  }

  /* send SQL query */
  if (mysql_query(conn, "show tables")) {
      fprintf(stderr, "%s\n", mysql_error(conn));
      exit(1);
  }

  res = mysql_use_result(conn);

  /* output table name */
  printf("MySQL Tables in mysql database:\n");
  while ((row = mysql_fetch_row(res)) != NULL)
      printf("%s \n", row[0]);

  /* close connection */
  mysql_free_result(res);
  mysql_close(conn);
}

To link the extra header files (like mysql.h) we will use some extra parameter to compile the code. Suppose the file is in desktop the name of the file is "input-file.c". So the compilation command will be

Code:

cd Desktop/
gcc -o output-file $(mysql_config --cflags) input-file.c $(mysql_config --libs)

Now, it is ready to run.

Code:

./output-file

Good work thanks!

this is a very very good job

well done