CODEWITHSUNDEEP
c++mysqlcodeblocks
Sakil
Sakil

Reputation: 1103

How to integrate MySQL with codeblocks IDE

I have been searching solution for this problem whole day.Any help would make me grateful. I am using Code::blocks IDE 16.01. I want to connect from my IDE to my MySQL database server. I have tried a lot of options but yet to succeed. I have my MYSQL INSTALLER setup already and have downloaded the mysql connector and mysql server. I am gonna show you the code and the way i have already tried.

This is my simple code 

#include <iostream>
#include <windows.h>
#include <mysql.h>
using namespace std;
int main()
{
   MYSQL* conn;
   conn = mysql_init(NULL);
   if (mysql_real_connect(conn,"localhost","root","","test",0,NULL,0) !=0)
   {
      cout << "Succesfully  Connected to MySQL database xxxx" << endl;
   }

    mysql_close(conn);

   return 0;
}

I have my MySQL setup in C drive and I have linked that as below

Library files linking

Include foldes

Include folder

After doing all the work I have been shown the following errors

Errors shown

Please someone help me. Thanks in advance. Please feel free to ask If you guyz need anything to know.

Upvotes: 2

Views: 4254

Answers (1)

Sergio
Sergio

Reputation: 941

In third step of your CodeBlocks setup you must specify the lib path (and not the include path), as below:
C:\Program Files\MySQL\MySQL Server 8.0\lib .
Then rebuilds your application.

Upvotes: 1

Related Questions