linux下c 访问mysql数据库_Linux下C连接MySQL数据库方法

#include

#include

#include

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