linuxÏÂcÓïÑÔÁ¬½ÓmysqlÊý¾Ý¿â

ÔÚFC8ÖÐĬÈÏ°²×°µÄÓÐmysql£¬Ã»ÓеĻ°¿ÉÒԺܷ½±ãµÄ°²×°Ï¡£
ĬÈϵÄmysqlµÄincludeÎļþĿ¼ÔÚ/usr/include/mysql
ĬÈϵÄmysqlµÄlibÎļþ¼ÐÔÚ/usr/lib/mysql
ÕâÁ½¸öĿ¼ÔÚÎÒÃDZàÒëʱºòÐèÒªµ½¡£
ÎҵIJâÊÔÓõÄC´úÂëΪ£º
££include <stdio.h>
#include <stdlib.h>
#include <mysql.h>
#define CONN_HOST "localhost"
#define CONN_USER "root"
#define CONN_PASS "123"
#define CONN_DB "test"
int main()
{
    MYSQL *conn;
    char *server =  CONN_HOST;
    char *user = CONN_USER;
    char *pass = CONN_PADD;
    char *database = CONN_DB;
    conn = mysql_init(NULL);
    if(!mysql_real_connect(conn,server,user,pass,database,0,NULL,0))
    {
       fprintf(stderr,"%s\n",mysql_error(conn));
       exit(1);
    }
    else
    {
       printf("ok!\n");
    }
    mysql_close(conn);
    return 0;
}
±àÒëÃüÁîΪ£º
gcc -o connMysql connMysql.c -I /usr/include/mysql/ -L /usr/lib/mysql/ -lmysqlclient