使用CMake连接MySQL与C++时头文件无法打开的问题求助

我要开发一个将用户信息存入MySQL数据库的C程序，采用CMake编译、VSCode作为IDE。已安装MySQL及MySQL C Connector，但IDE提示#include <mysql/cppconn>等语句无法打开源文件。已确认MySQL C++ Connector路径包含所需头文件，但问题仍未解决，附上相关代码求帮忙。

头文件代码（Database.hpp） #

#ifndef DATABASE_HPP
#define DATABASE_HPP

#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/prepared_statement.h>
#include <cppconn/statement.h>
#include <cppconn/resultset.h>
#include <memory>
#include <string>

class Database {
public:
    // Constructor to initialize database connection
    Database();

    // Method to add a new account to the database
    void AddAccount(int accountID, const std::string& name, double balance, const std::string& password);

    // Method to update the account balance after a transaction
    void UpdateBalance(int accountID, double new_balance);

private:
    sql::mysql::MySQL_Driver *driver;
    std::unique_ptr<sql::Connection> con;
};

#endif

根目录CMakeLists.txt代码 #

cmake_minimum_required(VERSION 3.25.0)

set(This Castle)

project(${This} C CXX)
set(CMAKE_C_STANDARD 99)
set(CMAKE_CXX_STANDARD 23)
set(CMAKE_CXX_STANDARD_REQUIRED ON)
set(CMAKE_POSITION_INDEPENDENT_CODE ON)

# Enable testing
enable_testing()

# Add GoogleTest subdirectory
add_subdirectory(googletest)

# Include directory for your headers
include_directories(${CMAKE_SOURCE_DIR}/include)

# Find OpenSSL package (make sure OpenSSL is installed and the path is correct)
find_package(OpenSSL REQUIRED)
include_directories(${OPENSSL_INCLUDE_DIR})

# Find MySQL Connector/C++ package
include_directories("C:/Program Files/MySQL/MySQL Connector C++ 9.0/include/mysql")
link_directories("C:/Program Files/MySQL/MySQL Connector C++ 9.0/lib64")

# Include MySQL Connector/C++ directories
include_directories(${MYSQLCONNECTORCPP_INCLUDE_DIRS})

# Your source and header files
set(Headers
    include/account.hpp
    include/security.hpp
    include/transaction.hpp
    include/auditLog.hpp
)

set(Sources
    src/account.cpp
    src/security.cpp
    src/transaction.cpp
    src/auditLog.cpp
)

# Create a static library
add_library(${This} STATIC ${Sources} ${Headers})

# Link OpenSSL and MySQL Connector libraries to your static library
target_link_libraries(${This} PUBLIC OpenSSL::SSL OpenSSL::Crypto ${MYSQLCONNECTORCPP_LIBRARIES})

# Add subdirectory for tests
add_subdirectory(tests)

问题修复步骤 #

1. 修正CMake头文件包含路径 #

你当前把include/mysql加入了包含路径，但mysql_driver.h在include/mysql下，cppconn是include的直接子目录，正确的包含路径应该是Connector的顶层include目录：

# 替换原来的mysql子目录路径
include_directories("C:/Program Files/MySQL/MySQL Connector C++ 9.0/include")

同时删掉无效的include_directories(${MYSQLCONNECTORCPP_INCLUDE_DIRS})——你没定义这个变量，这条语句没用。

2. 正确链接MySQL库 #

你用的${MYSQLCONNECTORCPP_LIBRARIES}未定义，直接写库名更靠谱，Connector 9.0的核心库是mysqlcppconn.lib（Debug模式下可能是mysqlcppconn-staticd.lib，根据你的编译模式调整）：

target_link_libraries(${This} PUBLIC 
    OpenSSL::SSL 
    OpenSSL::Crypto 
    mysqlcppconn
)

3. 补充Database.hpp到CMake的头文件列表 #

你的Headers集合里没包含Database.hpp，如果这个文件在include目录下，必须加进去，否则CMake可能不会处理它：

set(Headers
    include/account.hpp
    include/security.hpp
    include/transaction.hpp
    include/auditLog.hpp
    include/Database.hpp  # 新增这一行
)

4. 同步VSCode IntelliSense配置 #

如果CMake配置正确但VSCode仍报错，手动给IntelliSense加路径：

• 按Ctrl+Shift+P，输入C/C++: Edit Configurations (JSON)
• 在includePath数组中添加Connector的include路径：

  "includePath": [
      "${default}",
      "${CMAKE_SOURCE_DIR}/include",
      "C:/Program Files/MySQL/MySQL Connector C++ 9.0/include"
  ]
  

5. 验证路径正确性 #

确认Connector的include目录下确实有：

• mysql/mysql_driver.h
• cppconn/prepared_statement.h等文件
  如果路径不对，根据你实际安装的路径调整（比如可能是MySQL Connector C++ 8.0而非9.0）。

内容的提问来源于stack exchange，提问作者pikklefish