#include<stdlib.h>
#include<stdio.h>
#include<mysql.h>
int main(int argc,char* argv[])
{
MYSQL *conn_ptr;
conn_ptr = mysql_init(NULL);
if(!conn_ptr){
fprintf(stderr,"mysql_init failed\n");
return EXIT_FAILURE;
}
conn_ptr = mysql_real_connect( conn_ptr, "localhost", "li", "li","mysql", 0, NULL, 0 );
if(conn_ptr){
printf("Connection success\n");
}else{
printf( "Connection failed\n");
}
mysql_close( conn_ptr );
return 0;
}
编译方法:
gcc $(mysql_config --cflags) xxx.c -o xxx $(mysql_config --libs)
方法二:gcc test.c -o test -L/user/lib/mysql -lmysqlclient 成功!
方法三:gcc test.c -o test $(mysql_config --cflags) $(mysql_config --libs)
或者:gcc test.c -o test $(mysql_config --cflags --libs) 成功!