CLion中运行MySQL Connector遇依赖及类型定义冲突问题求助

Hey Timothy, let's work through these compilation issues you're facing with MySQL Connector C++ in CLion. I'll break down the solutions step by step:

1. Fixing int32_t/uint32_t Conflicting Declarations #

This error happens because MySQL Connector's cppconn/config.h tries to define standard integer types manually, but MinGW's standard library already provides these definitions in stdint.h. To fix this:

• Add a compile definition to tell the Connector to skip redefining these standard types. Update your CMakeLists.txt with this line (preferably after creating your executable target):

  target_compile_definitions(Learn_Cpp PRIVATE MYSQLCPP_NO_STDTYPES)
  

This flag disables the custom type declarations in the Connector's header, forcing it to use the standard ones from your MinGW toolchain.

2. Clean Up Your CMake Configuration #

Looking at your original CMakeLists.txt, there are a few tweaks that will help avoid future issues and fix any lingering Boost/Connector path problems:

• Fix duplicate source file: You have Learn.cpp listed twice in SOURCE_FILES—remove the duplicate to prevent redundant compilation.
• Correct link directories: Your original LINK_DIRECTORIES entries are incomplete. You need to point to the actual library folders for MySQL Connector and Boost. For example, MySQL Connector's lib path is usually something like C:/Program Files/MySQL/MySQL Connector C++ 1.1.9/lib/opt (adjust based on whether you're using debug/release builds).
• Use modern CMake practices: Prefer target_link_libraries over global LINK_DIRECTORIES where possible, and keep your include paths organized.

Here's a revised, cleaner version of your CMakeLists.txt:

cmake_minimum_required(VERSION 3.8)
project(Learn_Cpp)
set(CMAKE_CXX_STANDARD 17)

# Include directories for headers
include_directories(
    "C:/Program Files/MySQL/MySQL Connector C++ 1.1.9/include"
    "C:/Boost/boost_1_66_0"
)

# Link directories for libraries (update paths to match your setup)
link_directories(
    "C:/Program Files/MySQL/MySQL Connector C++ 1.1.9/lib/opt"
    "C:/Boost/boost_1_66_0/libs"
)

# Source files (removed duplicate Learn.cpp)
set(SOURCE_FILES
    "C++ Tutorials/Learn.cpp"
    "C++ Tutorials/ClassFile.cpp"
    "C++ Tutorials/ClassFile.h"
    "C++ Tutorials/Classes_and_simple_prgm.cpp"
)

add_executable(Learn_Cpp ${SOURCE_FILES})

# Link required libraries (adjust library names if using debug builds, e.g., mysqlcppconn-static)
target_link_libraries(Learn_Cpp
    mysqlcppconn
    # Add Boost libraries here if you need them, e.g., boost_system
)

# Fix for integer type conflicts
target_compile_definitions(Learn_Cpp PRIVATE MYSQLCPP_NO_STDTYPES)

3. Double-Check Boost Setup #

Since you resolved the boost/config/user.hpp error, just make sure:

• Your Boost installation's root directory contains the boost subfolder (which it does in your path C:/Boost/boost_1_66_0).
• If you're using non-header-only Boost libraries, you've built them for MinGW (since CLion uses MinGW here).

After making these changes, clean your CLion build directory (Build > Clean Project) and rebuild—this should resolve both the type conflict and any lingering path issues.

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