User forums > Using Code::Blocks

mysql problem

(1/1)

Michiel:
Hello, I'm trying to get Mysql working with codeblocks. I've linked the libraries (libmysql.lib an d mysqlclient.lib) an set the search directory to the mysql include folder.

It is actually linking the libraries (if I change the name I get an error), but when compiling I get errors about undefined references to mysql_init, mysql_query etc.

This is the code:

--- Code: ---#include <iostream>

#include "mysql.h"

using namespace std;

MYSQL_RES* Perform_Query(MYSQL* connection, const char* query)
{
    // send the query to the database
   if (mysql_query(connection, query))
   {
      cout << "MySQL query error : %s\n" << mysql_error(connection) << endl;
      exit(1);
   }

    return mysql_use_result(connection);
}

int main()
{
    string mainServer="127.0.0.1";
    string mainDbUser="root";
    string mainDbPass="warmoes";
    MYSQL *connect; //database connection variable

    connect=mysql_init(NULL);
    if(!connect)
        cout<<"Couldn't initiate connector\n";

    if (mysql_real_connect(connect, mainServer.c_str(), mainDbUser.c_str(), mainDbPass.c_str(), "test" ,0,NULL,0))
    {
        cout<<"Connection done\n";
        MYSQL_RES* res = Perform_Query(connect, "show tables");
        cout << "Tables in database test" << endl;
        MYSQL_ROW row;
        while ((row = mysql_fetch_row(res)) != NULL)
        {
            cout << row[0] << endl;
        }
        mysql_free_result(res);

    }
    else
    {
        cout<<mysql_error(connect)<<endl;
    }
    mysql_close (connect);
    return 0;
}

--- End code ---

Any clues on what's going wrong here? I work on Windows 7.

stahta01:
Post a full rebuild log!

http://wiki.codeblocks.org/index.php/FAQ-Compiling_(errors)#Q:_How_do_I_troubleshoot_a_compiler_problem.3F

Michiel:
Hope this clarifies something...

-------------- Clean: Debug in test20181002db1 (compiler: GNU GCC Compiler)---------------

Cleaned "test20181002db1 - Debug"

-------------- Build: Debug in test20181002db1 (compiler: GNU GCC Compiler)---------------

mingw32-g++.exe -Wall -fexceptions -g -I"C:\Program Files\MySQL\MySQL Server 8.0\include" -I"C:\Program Files\MySQL\MySQL Server 8.0\include" -IC:\wxWidgets-3.0.4\include -I"C:\Program Files\MySQL\MySQL Server 8.0\include" -c D:\Michiel\Documents\C++\test20181002db1\main.cpp -o obj\Debug\main.o
mingw32-g++.exe -L"C:\Program Files\MySQL\MySQL Server 8.0\include" -LC:\wxWidgets-3.1.1\lib\ -L"C:\Program Files\MySQL\MySQL Server 8.0\include" -o bin\Debug\test20181002db1.exe obj\Debug\main.o   "C:\Program Files\MySQL\MySQL Server 8.0\lib\libmysql.lib" "C:\Program Files\MySQL\MySQL Server 8.0\lib\mysqlclient.lib" "C:\Program Files\MySQL\MySQL Server 8.0\lib\libmysql.lib" "C:\Program Files\MySQL\MySQL Server 8.0\lib\mysqlclient.lib" "C:\Program Files\MySQL\MySQL Server 8.0\lib\libmysql.lib" "C:\Program Files\MySQL\MySQL Server 8.0\lib\mysqlclient.lib"
obj\Debug\main.o: In function `Z13Perform_QueryP5MYSQLPKc':
D:/Michiel/Documents/C++/test20181002db1/main.cpp:10: undefined reference to `mysql_query@8'
D:/Michiel/Documents/C++/test20181002db1/main.cpp:12: undefined reference to `mysql_error@4'
D:/Michiel/Documents/C++/test20181002db1/main.cpp:16: undefined reference to `mysql_use_result@4'
obj\Debug\main.o: In function `main':
D:/Michiel/Documents/C++/test20181002db1/main.cpp:26: undefined reference to `mysql_init@4'
D:/Michiel/Documents/C++/test20181002db1/main.cpp:30: undefined reference to `mysql_real_connect@32'
D:/Michiel/Documents/C++/test20181002db1/main.cpp:36: undefined reference to `mysql_fetch_row@4'
D:/Michiel/Documents/C++/test20181002db1/main.cpp:40: undefined reference to `mysql_free_result@4'
D:/Michiel/Documents/C++/test20181002db1/main.cpp:45: undefined reference to `mysql_error@4'
D:/Michiel/Documents/C++/test20181002db1/main.cpp:47: undefined reference to `mysql_close@4'
collect2.exe: error: ld returned 1 exit status
Process terminated with status 1 (0 minute(s), 2 second(s))
10 error(s), 0 warning(s) (0 minute(s), 2 second(s))
 

sodev:
These MySQL libraries, you didn't compile them yourself, did you? Because they look like they have been made with MSVC and you try to link them with GCC. Although they are only in C this usually does not work.

Best solution would be to compile MySQL (or at least only the client library) with your GCC, or compile your application with MSVC (but it better has to be the same MSVC compiler version or you will need two different runtimes at runtime).

Michiel:
Thanks, I will give it a try!

Navigation

[0] Message Index