VS2019 connects to mysql8.0 database tutorial with pictures and text

1. First, prepare VS2019 and MySQL database. Both can be downloaded from the official website. We will directly describe the connection process.

2. Connection:

Step 1: Open the MySQL installation directory. My local installation directory is as follows: (Note whether there are include and lib folders)

Step 2: Open VS2019 and create a new empty project.

Step 3: Right-click the project name to open the property page:

Step 4: Open VC++ directory, in the include directory, add the path of the include file in the mysql installation file here:

Step 5: Still on the property page, open C/C++, select General, and add the include file path in the mysql file in the additional include directory as in the previous step:

Step 6: Still on the property page, click the linker option, click General, and add the lib file path in the mysql installation folder to the additional library directory:

Step 7: Still in the linker of the property page, click the second input and change Add the libmysql.lib file. Note that Add the dependency name libmysql.lib without adding the path. This file is also in the lib directory of the MySQL installation folder:

Step 8: Check the platform at the top of the property page and select x64. x32 may cause an error.

Step 9: Copy bin\libmysql.dll in the MySQL installation directory to c:\windows\system32:

If you don't do this step, you will probably get an error when you run the program. libmysql.dll not found error.

3. Write test code:

First open the MySQL database. I use a local database table to test:

Test code:

#include <stdio.h>
#include "mysql.h"
#include<iostream>
using namespace std;
void main()
{
	MYSQL mysql; //A database structure MYSQL_RES* res; //A result set structure MYSQL_ROW row; //char** two-dimensional array, storing records one by one //Initialize the database mysql_init(&mysql);
	//Set encoding mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "gbk");
	//Connect to database //If the connection fails, the information about the connection failure will be displayed so that we can make corresponding modifications.
	// mysql_real_connect parameters: 2. Local address 3. Your mysql username 4. Your mysql password 5. Database name 6. Port number if (mysql_real_connect(&mysql, "localhost", "root", "root", "luckysheep", 3306, NULL, 0) == NULL) {
		cout << (mysql_error(&mysql));
	}
	//Query data mysql_query(&mysql, "SELECT * from department");
	//Get the result set res = mysql_store_result(&mysql);
	//Display data //Assign a value to ROW, determine whether ROW is empty, and print the data if it is not empty.
	while (row = mysql_fetch_row(res))
	{
		printf("%s ", row[0]); //Print ID
		printf("%s ", row[1]); //Print ID
		cout << endl;
	}
	//Free the result set mysql_free_result(res);
	//Close the database mysql_close(&mysql);
	//Stop and wait for getchar();
}

Be sure to change your mysql username and password.
Output:

Record: Actually, I wanted to connect vs2010 to mysql today, because the project was carried out in vs2010, and I wanted to connect to the database for data testing, etc. But after a whole day of installation, solving one error after another, it still failed in the end, and #include <stdbool.h> showed an error. After some research, I found out that the C language does not support the Boolean type built-in. By referencing the stdbool.h header file, I can make it support the Boolean type. But VS2010 does not fully support C99...stdbool.h is C99...Time is tight, I will check it out later when I have time. . . . .

Summarize

This is the end of this article about connecting VS2019 to MySQL 8.0 database. For more relevant content about connecting VS2019 to MySQL 8.0 database, please search previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!