在CentOS中搭建MySQL开发环境

一.部署mysql-connector-c

下载mysql-connector-c-6.1.5-linux-glibc2.5-x86_64.tar.gzhttp://cdn.mysql.com/Downloads/Connector-C/mysql-connector-c-6.1.5-linux-glibc2.5-x86_64.tar.gz
解压缩mysql-connector-c-6.1.5-linux-glibc2.5-x86_64.tar.gz，输入命令：tar xvzf mysql-connector-c-6.1.5-linux-glibc2.5-x86_64.tar.gz将解压缩获得目录重命名为mysqlclient
进入mysqlclient目录
将include目录拷贝到/usr/include/mysqlclient目录下，输入命令：cp -r include/ /usr/include/mysqlclient
将lib目录拷贝到/usr/lib64/mysqlclient目录下，输入命令：cp -r lib/ /usr/lib64/mysqlclient

二.部署mysql-connector c++

下载mysql-connector-c++-1.1.1-linux-glibc2.3-x86-64bit.tar.gzhttp://cdn.mysql.com/Downloads/Connector-C++/mysql-connector-c++-1.1.1-linux-glibc2.3-x86-64bit.tar.gz
解压缩mysql-connector-c++-1.1.1-linux-glibc2.3-x86-64bit.tar.gz，输入命令：tar xvzf mysql-connector-c++-1.1.1-linux-glibc2.3-x86-64bit.tar.gz将解压缩得到的目录重命名为mysqlcppconn
进入mysqlcppconn目录
将include目录拷贝到/usr/include/mysqlcppconn目录下，输入命令：cp -r include/ /usr/include/mysqlcppconn
将lib目录拷贝到/usr/lib64/mysqlcppconn目录下，输入命令：cp -r lib/ /usr/lib64/mysqlcppconn

三.设置GCC-G++相关的环境变量

修改环境变量CPLUS_INCLUDE_PATH,LIBRARY_PATH,LD_LIBRARY_PATH
进入/home/$your_username目录，输入命令：vi .bash_profile（使用VI编辑器修改.bash_profile文件)修改内容如下：
CPLUS_INCLUDE_PATH=/usr/include/mysqlcppconn:/usr/include/mysqlclient
export CPLUS_INCLUDE_PATH
LIBRARY_PATH=/usr/lib64:/usr/lib64/mysqlclient:/usr/lib64/mysqlcppconn
export LIBRARY_PATH
LD_LIBRARY_PATH=/usr/lib64:/usr/lib64/mysql:/usr/lib64/mysqlcppconn
export LD_LIBRARY_PATH
保存后，在Terminal输入命令，source .bash_profile，以使修改的内容立即生效。
输入命令：echo $CPLUS_INCLUDE_PATH，查看环境变量的值

四.编写测试程序

创建testmysql目录，新建文件main.cpp代码如下：

#include <iostream>
#include <sstream>
#include <memory>
#include <string>
#include <stdexcept>

using namespace std;

#include <mysql_connection.h>
#include <mysql_driver.h>
#include <cppconn/driver.h>
using namespace sql;

#define DBHOST "tcp://localhost:3306"
#define USER "root"
#define PASSWORD "123456"

int main()
{
    Driver* driver = NULL;
    Connection* conn = NULL;
    driver = mysql::get_driver_instance();
    conn = driver->connect(DBHOST, USER, PASSWORD);
    conn->setAutoCommit(0);
    cout<< "DataBase connection autocommit mode ="<<conn->getAutoCommit() <<endl;
    delete conn;
    driver = NULL;
    conn = NULL;
    return 0;
}