After add executable link the library using target_link_libraries(main mysql::concpp) . You don't need to find the library files or define the include directory for this. fund_package ensures that they are populated for your project.
target_link_libraries(main mysql::concpp)