VS2010连接mysql数据库

    用visual studio 2010连接mysql数据库。  

    (1)在VS中新建一个控制台项目mysql_test。

    (2)选择Project->Properties->Configuration Properties:

       1）->VC++ Directories->Include Directories目录中添加“D:\Program Files\MySql\MySQL Server 5.5\include(此处安装mysql的安装目录更改路径)”。

       2)->VC++ Directories->Library Directories目录中添加“D:\Program Files\MySql\MySQL Server 5.5\lib”和“D:\Program Files\MySql\MySQL Server 5.5\lib\debug”

       3)->Linker->Input->Additional Dependencies项中添加libmysql.lib

    (3)将mysql安装文件中lib目录下的ibmysql.dll文件放到vs项目文件中的Debug目录下。

    (4)编写代码、建立连接    

#include<winsock.h>
#include<windows.h>
#include<mysql.h>
#include<stdio.h>
#include<string.h>
#include<stdlib.h>
#pragma comment (lib,"libmysql.lib")
#pragma comment (lib,"mysqlclient.lib")

int main()
{
	MYSQL *connection;
	connection = mysql_init((MYSQL *) 0);

	//Connect to the DB
	if(mysql_real_connect(connection, NULL, "root", "*****","table_name",0,NULL,0))
	{
		printf("Succeed in connecting to the database !\n");

		mysql_close(connection);
	}
	return TRUE;
}