¸ßÊÖÇë½ø£ºlinux mysql C api£» Á¬½ÓÊý¾Ý¿âÎÊÌâ

ÔËÐл·¾³£º redhat£º 4
          gcc£º    3.4
          mysql£º  5.1

#include <stdio.h>
#include "/usr/include/mysql/mysql.h"

MYSQL_RES*  res_ptr;
MYSQL_ROW  sqlrow;
 
unsigned int num_rows = 0;
char ch_sql[200];
MYSQL      my_conn; 
   
int main(){

      mysql_init(&my_conn);

    if (!mysql_real_connect(&my_conn, "localhost", "root", "123456","test",0,NULL,CLIENT_FOUND_ROWS)) {
   
        printf( "ERROR: connect database error\n" );
        return 0;
    }
   
    printf( "Successful!\n\n" );
    return 0;
}

±àÒ룺gcc sqltest.c $(mysql_config --cflags) $(mysql_config --libs) -o sqltest
ÔËÐУº./sqltest

´íÎó£ºcan't connect to localmysql server through socket '/tmp/mysql.sock'

Áí£º 1./tmp/mysql.sockȷʵ´æÔÚ£¬¶øÇÒmysqlÔËÐÐÕý³£
    2.ͬһÓû§Ï£¬Í¨¹ýÃüÁîÐУºmysql -u root -p123456; ¿ÉÒÔÕý³£½øÈë
    3.ÔÚ±¾µØ»úÆ÷UbuntuÏ£¬±àÒëÔËÐÐÕý³££»Î¨Ò»²»Í¬µÄ¾ÍÊÇgcc°æ±¾

¼±£¡Çë¸ßÊÖÖ