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