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

来源：互联网发布：印度种姓知乎编辑：程序博客网时间：2024/06/05 11:43

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 网上好多写这样的，让我查了半天也没找出哪错了。。。这样编译不通过