Codeblocks MySQL Tutorial

Techwalla may earn compensation through affiliate links in this story.
You can conenct to MySQL and manipulate its data in Code::Blocks.

Code::Block is an open source C++ IDE built to meet the complicated development aims of the users. It is developed to be very extensible and configurable. The IDE has the following features: rapid custom build system, support for parallel builds, multi-target projects, user-defined watches, call stack, switch between threads, class browsing and smart indent. MySQL is a popular open source database management system. You can connect to MySQL database in Code::Block and manipulate the data such as retrieve, update, insert and delete.


Step 1

Download Code::Blocks setup file from its official website (see resources.) Double-click the setup file to start the installation. Follow the installation wizard until completion.

Video of the Day

Step 2

Double-click the Code::Blocks icon to enter the development interface. Click "Settings," "Compiler and Debugger" and "Linker Settings." Click "Link Library" tab to open the dialog window. Click "Add" button and input "/usr/lib/"


Step 3

Click "Settings," "Compiler and Debugger" and "Search directories." Select "Compiler" and input "/usr/include/mysql." The development environment with MySQL is properly configured.

Step 4

Include the following files in your application:


#include <mysql.h> #include <MySQLManager.h>

Step 5

Connect to MySQL using the MySQLManager function:

MySQLManager::MySQLManager(string hosts, string userName, string password, string dbName, unsigned int port)
IsConnected = false;
this ->setHosts(hosts);
this ->setUserName(username);
this ->setPassword(password);
this ->setDBName(database);
this ->setPort(port); }



Step 6

Conduct SQL queries via function runSQLCommand:

bool MySQLManager::runSQLCommand(string sql)
mysql_real_query(&mySQLClient,sql.c_str(),(unsigned int)strlen(sql.c_str())); }


Step 7

Define your Main function using the said functions:

int main(){ MySQLManager sqlres("","root","search1","HR",3306); sqlres.initConnection(); sqlres.runSQLCommand("select * from employee"); sqlres.destroyConnection(); return 0; }



Report an Issue

screenshot of the current page

Screenshot loading...