1. 安装依赖 sudo apt install mysql-server mysql-client libmysqlclient-dev
2. 建立测试文件test.cpp
/* test.cpp */
#include <mysql.h>
#include <iostream>
int main() {
MYSQL *conn;
MYSQL_RES *res;
MYSQL_ROW row;
const char *server = "localhost";
const char *user = "root";
const char *password = ""; /* 此处改成你的密码 */
const char *database = "mysql"; /* 数据库名字,比如mysql*/
conn = mysql_init(NULL);
/* 连接数据库 */
if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
cout << mysql_error(conn);
return -1;
}
/* 查询语句 */
if (mysql_query(conn, "show tables")) {
cout << mysql_error(conn));
return -2;
}
res = mysql_use_result(conn);
/* 打印查询结果 */
while ((row = mysql_fetch_row(res)) != NULL) printf("%s \n", row[0]);
/* 断开连接 */
mysql_free_result(res);
mysql_close(conn);
}
3. 使用g++编译,其中-I为包含目录,-L为包含库目录
g++ test.cpp -o test.app -I /usr/include/mysql -L/usr/lib/mysql -lmysqlclient
4. 使用cmake编译,建立CMakeLists.txt
/* CMakeLists.txt */
cmake_minimum_required(VERSION 3.8)
project("SQL_test")
include_directories(/usr/include/mysql)
add_executable(test.app "test.cpp")
target_link_libraries(test.app mysqlclient)