Подключение к БД: неразрешенный внешний символ "_mysql_close@4"

#include <windows.h> 
#include <iostream> 
#include <mysql.h> 
#pragma comment ( lib, "libmysql.lib" )
using namespace std;
 
int main() 
{ 
    //connection params 
    char *host = "localhost"; 
    char *user = "root"; 
    char *pass = ""; 
    char *db = "";
 
    //sock 
    MYSQL *sock; 
    sock = mysql_init(0); 
    if (sock) cout << "sock handle ok!" << endl; 
    else { 
        cout << "sock handle failed!" << mysql_error(sock) << endl; 
    }
 
    //connection 
    if (mysql_real_connect(sock, host, user, pass, db, 0, NULL, 0)) 
        cout << "connection ok!" << endl; 
    else { 
        cout << "connection fail: " << mysql_error(sock) << endl; 
    } 
    
    //connection character set 
    cout << "connection character set: " << mysql_character_set_name(sock) << endl; 
    //wait for posibility to check system/mysql sockets 
    system("PAUSE"); 
    
    //closing connection 
    mysql_close(sock); 
    return EXIT_SUCCESS; 
}

#include <stdio.h>
#include <stdlib.h>
#include <stdarg.h>
#include <my_global.h>
#include <mysql.h>
#include <iostream>
 
#pragma comment(lib, "libmysqld.lib")
using namespace std;
 
int main() 
{ 
    //connection params 
    char *host = "192.168.*.*"; 
    char *user = "*"; 
    char *pass = "******"; 
    char *db = "";
 
    //sock 
    MYSQL *sock; 
    sock = mysql_init(0); 
    if (sock) cout << "sock handle ok!" << endl; 
    else { 
        cout << "sock handle failed!" << mysql_error(sock) << endl; 
    }
 
    //connection 
    if (mysql_real_connect(sock, host, user, pass, db, 0, NULL, 0)) 
        cout << "connection ok!" << endl; 
    else { 
        cout << "connection fail: " << mysql_error(sock) << endl; 
    } 
    
    //connection character set 
    cout << "connection character set: " << mysql_character_set_name(sock) << endl; 
    //wait for posibility to check system/mysql sockets 
    system("PAUSE"); 
    
    //closing connection 
    mysql_close(sock); 
    return EXIT_SUCCESS; 
}

#include <my_global.h>
#include <mysql.h>

/*#pragma comment (lib,"mysqlclient.lib")
#pragma comment(lib, "Ws2_32.lib")
#pragma comment (lib,"libmysql.lib")
#define __LCC__
*/
 
#include <my_global.h>
#include <mysql.h>
 
 
#include <iostream>
#include <string>
#include <vector>
 
#pragma comment ( lib, "libmysql.lib" )

1>------ Build started: Project: Test 2, Configuration: Debug Win32 ------
1>Compiling...
1>OperariDbMysql.cpp
1>Linking...
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_init@4 referenced in function "public: __thiscall OperariDbMysql::OperariDbMysql(void)" (??0OperariDbMysql@@QAE@XZ)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_error@4 referenced in function "public: void __thiscall OperariDbMysql::Connect(char * const,char * const,char * const)" (?Connect@OperariDbMysql@@QAEXQAD00@Z)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_real_connect@32 referenced in function "public: void __thiscall OperariDbMysql::Connect(char * const,char * const,char * const)" (?Connect@OperariDbMysql@@QAEXQAD00@Z)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_close@4 referenced in function "public: __thiscall OperariDbMysql::~OperariDbMysql(void)" (??1OperariDbMysql@@QAE@XZ)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_num_rows@4 referenced in function "public: void __thiscall OperariDbMysql::Query(char const *)" (?Query@OperariDbMysql@@QAEXPBD@Z)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_num_fields@4 referenced in function "public: void __thiscall OperariDbMysql::Query(char const *)" (?Query@OperariDbMysql@@QAEXPBD@Z)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_store_result@4 referenced in function "public: void __thiscall OperariDbMysql::Query(char const *)" (?Query@OperariDbMysql@@QAEXPBD@Z)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_errno@4 referenced in function "public: void __thiscall OperariDbMysql::Query(char const *)" (?Query@OperariDbMysql@@QAEXPBD@Z)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_query@8 referenced in function "public: void __thiscall OperariDbMysql::Query(char const *)" (?Query@OperariDbMysql@@QAEXPBD@Z)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_free_result@4 referenced in function "public: bool __thiscall OperariDbMysql::UserRegistration(class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >,class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >,class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >,class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >,class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >,class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >,class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >)" (?UserRegistration@OperariDbMysql@@QAE_NV?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@000000@Z)
1>OperariDbMysql.obj : error LNK2019: unresolved external symbol _mysql_fetch_row@4 referenced in function "public: class std::vector<char const *,class std::allocator<char const *> > __thiscall OperariDbMysql::GetContacts(class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >)" (?GetContacts@OperariDbMysql@@QAE?AV?$vector@PBDV?$allocator@PBD@std@@@std@@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@3@@Z)
1>D:\Programing\My\Test programs\Test 2\Debug\Test 2.exe : fatal error LNK1120: 11 unresolved externals
1>Build log was saved at "file://d:\Programing\My\Test programs\Test 2\Test 2\Debug\BuildLog.htm"
1>Test 2 - 12 error(s), 0 warning(s)
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========