MacOS VsCode C++连接mysql

使用Cmake

1.CmakeLists.txt配置

cmake_minimum_required(VERSION 3.18)
project(MYSQL)
include_directories("/usr/local/mysql-8.0.21-macos10.15-x86_64/include") //添加头文件
link_directories("/usr/local/mysql-8.0.21-macos10.15-x86_64/lib") //指定链接库文件路径
set(CMAKE_CXX_STANDARD 17) 
add_executable(main main.cpp) //生成可执行文件
target_link_libraries(main libmysqlclient.dylib) //链接动态库

2.main.cpp

#include <mysql.h>
#include <string>
#include <iostream>
using namespace std;
int main()
{
    string user = "root"; //用户名
    string pwd = "root123"; //密码
    string host = "localhost";
    string db = "C++Web"; //数据库名
    unsigned int port = 3306;
    MYSQL myCont;
    mysql_init(&myCont);
    if (mysql_real_connect(&myCont, host.c_str(), user.c_str(), pwd.c_str(), db.c_str(), port, NULL, 0))
    {
        cout << "connect successfully" << endl;
    }
    else
    {
        cout << "connect failed" << endl;
    }
    mysql_close(&myCont);
    return 0;
}

3.运行

文件结构：