Results 1 to 4 of 4

Thread: error in connecting to mysql using C program

  1. #1
    Join Date
    Jun 2012
    Beans
    4

    Post error in connecting to mysql using C program

    Hi all

    I am trying to access mysql through a c program, bt am stuck with a specific error. I have searched the net for solutions, but nothin helped

    Code:

    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);
    }
    The command i used to compile the program is:
    gcc -o connectsql $(mysql_config --cflags) connectsql.c $(mysql_config --libs)

    Error:
    /tmp/ccx4qAGm.o: In function `main':
    connectsql.c: (.text+0x13f): undefined reference to`mysql_free_results'
    collect2: ld returned 1 exit status
    Last edited by fivestaar; July 11th, 2012 at 07:36 AM. Reason: error in typing

  2. #2
    Join Date
    Aug 2010
    Location
    Lancs, United Kingdom
    Beans
    1,033
    Distro
    Xubuntu 12.04 Precise Pangolin

    Re: error in connecting to mysql using C program

    Quote Originally Posted by fivestaar View Post
    Error:
    /tmp/ccx4qAGm.o: In function `main':
    connectsql.c: (.text+0x13f): undefined reference to`mysql_free_results'
    collect2: ld returned 1 exit status
    The code you have posted has mysql_free_result (singular correct) but the error message has mysql_free_results (plural incorrect). Are you sure that the code you are compiling has mysql_free_result not mysql_free_results?

  3. #3
    Join Date
    Jul 2012
    Beans
    1

    Re: error in connecting to mysql using C program

    While you have included the mySQL header files in your code, you haven't included the mySQL library in your link options.
    internet marketing tips and strategy
    effective internet marketing

  4. #4
    Join Date
    Jun 2012
    Beans
    4

    Re: error in connecting to mysql using C program

    Quote Originally Posted by spjackson View Post
    The code you have posted has mysql_free_result (singular correct) but the error message has mysql_free_results (plural incorrect). Are you sure that the code you are compiling has mysql_free_result not mysql_free_results?
    @spjackson thanks for pointing that out.
    I checked my program n there were some typing errors, Helped me solve the prob. SO silly of me to over look it

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •