ubuntu下c++使用mysqlconnector连接mysql数据库

1、安装mysqlconnector

sudo apt-get install libmysqlcppconn-dev

2、安装mysql

sudo apt-get install mysql-server

使用网上广泛引用的一个测试代码

#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://127.0.0.1:3306"
#define USER "root"
#define PASSWORD "your password here"

int main() {
   Driver *driver;
   Connection *conn;
   driver = 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;
}

使用 g++ -o testmysql  testmysql.cpp -lmysqlcppconn 编译文件，运行即可

一定注意不要写成g++ -o testmysql -lmysqlcppconn testmysql.cpp 网上好多写这样的，让我查了半天也没找出哪错了。。。这样编译不通过