c 与mysql连接_c语言如何连接MYSQL？

大家好:

我是搞C的, 现在想用C 连接MYSQL,但是怎么也连接不了,我的代码如下:

#include

#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"

int main()

{

MYSQL* mysql_a;

mysql_a = mysql_init(NULL);

if(mysql_a == NULL)

{

printf("init mysql failed\n");

return ER_BAD_DB_ERROR;

}

if (mysql_real_connect(mysql_a, "localhost", "root" , "123456", "lqiuiw",0, NULL, 0) == NULL)

{

printf("Failed to connect to database: Error: %u(%s)\n", mysql_errno(mysql),mysql_error(mysql));

mysql_close(mysql);

mysql = NULL;

return ER_BAD_DB_ERROR;

}

return 0;

}

出现的错误是:

--------------------Configuration: sdfs - Win32 Debug--------------------

Compiling...

sdfs.c

c:\program files\mysql\mysql server 5.0\