Linux下C连接MySQL数据库方法

#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)                        成功！