#include <stdio.h>

#include <mysql/mysql.h>

int main()

{

    //MYSQL句柄

    MYSQL mysql;

    /*用mysql_init初始化MYSQL连接句柄*/

    mysql_init(&mysql);

    /*使用mysql_real_connect连接服务器*/

    if(!mysql_real_connect(&mysql, "localhost", "root", "", "mydb", , NULL, )) {

        printf("Error:%s\n",mysql_error(&mysql));

    }else {

        printf("Connected Mysql successful!\n");

    }

    /*关闭连接*/

    mysql_close(&mysql);

    return ;

}

cc -o connect connect.c -L/usr/lib64/mysql -lmysqlclient

#include <stdio.h>

#include <string.h>

#include <mysql/mysql.h>

int main()

{

    MYSQL mysql;

    MYSQL_RES *res;

    MYSQL_ROW row;

    char *query;

    int flag, t;

    mysql_init(&mysql);

    if(!mysql_real_connect(&mysql, "localhost", "root", "", "mydb", , NULL, )) {

        printf("Failed to connect to Mysql!:%s\n",mysql_error(&mysql));

        return ;

    }else {

        printf("Connected to Mysql successfully!\n");

    }

    query = "select * from student";

    /*查询，成功则返回0*/

    flag = mysql_real_query(&mysql, query, (unsigned int)strlen(query));

    if(flag) {

        printf("Query failed!\n");

        return ;

    }else {

        printf("[%s] made...\n", query);

    }

    /*mysql_store_result将全部的查询结果读取到客户端*/

    res = mysql_store_result(&mysql);

    /*mysql_fetch_row检索结果集的下一行*/

    while(row = mysql_fetch_row(res)) {

        /*mysql_num_fields返回结果集中的字段数目*/

        for(t=; t<mysql_num_fields(res); t++)

        {

            printf("%s\t", row[t]);

        }

        printf("\n");

    }

    mysql_close(&mysql);

    return ;

}