一、下載mysql8.rar解壓到C盤(pán)(也可以解壓到其他位置)

在系統(tǒng)環(huán)境變量添加JAVA_HOME=C:\myslq8，并在path中添加%JAVA_HOME%\bin;

二、以管理員身份進(jìn)入命令窗口

三、修改配置文件指定安裝路徑和數(shù)據(jù)庫(kù)的存放路徑

四、鍵入如下命令初始化并啟動(dòng)mysql服務(wù),然后修改登錄密碼

C:\>mysqld --initialize --user=mysql --console
C:\>mysqld -install
C:\>net start MySQL
C:\>mysql -u root -p （回車(chē)讓輸入的密碼就是第一個(gè)命令后出現(xiàn)的臨時(shí)密碼）
mysql> ALTER USER root@localhost IDENTIFIED BY "12345678"; （新修改密碼自己指定）
mysql> flush privileges;
mysql> exit

五、手動(dòng)命令建數(shù)據(jù)庫(kù)的命令如下

C:\> mysql -u root -p
Enter password: ******** （上面自己修改的新密碼）
Welcome to the MySQL monitor.? Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.28 MySQL Community Server - GPL
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create testdatabase; （創(chuàng)建的數(shù)據(jù)庫(kù)為testdatabase）
mysql> use testdatabase;? （切換到剛建的數(shù)據(jù)庫(kù)）
mysql> create table customers (id INT PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255),address VARCHAR(255),city VARCHAR(255)); （創(chuàng)建表customers）
mysql> insert into customers (name,address,city) values('張三','海淀區(qū)','北京'); （插入新記錄）
mysql> select * from customers; （顯示新記錄）
+----+--------+-----------+--------+
| id | name?? | address?? | city?? |
+----+--------+-----------+--------+
|? 1 | 張三?? | 海淀區(qū)??? | 北京?? |
+----+--------+-----------+--------+
1 row in set (0.00 sec)

六、VS2022調(diào)試讀取源代碼如下

// TestMySQL.cpp : 此文件包含 "main" 函數(shù)。程序執(zhí)行將在此處開(kāi)始并結(jié)束。
//#include <stdio.h>
#include <iostream>
#include "include/mysql.h"using namespace std;
#pragma comment(lib,"lib/libmysql.lib")int main()
{MYSQL mysql;mysql_init(&mysql);if (!(mysql_real_connect(&mysql, "127.0.0.1", "root", "12345678", "testdatabase", 0, NULL, 0))){cout << "Connect database,fail!\n : ";cout << mysql_error(&mysql);exit(-1);}mysql_query(&mysql, "set names gbk");mysql_query(&mysql, "select * from customers where name = '張三'");MYSQL_RES* res = mysql_store_result(&mysql);if (res == NULL){mysql_close(&mysql);cout << mysql_error(&mysql);exit(-1);}MYSQL_ROW row;int count = mysql_num_fields(res);while (row = mysql_fetch_row(res)){for (int kkk = 0; kkk < count; kkk++){cout << row[kkk] << "\t";}cout << endl;}mysql_free_result(res);mysql_close(&mysql);return 0;
}

七、編譯時(shí)前要把mysql依賴(lài)庫(kù)和包含文件拷貝到工程下

?八、編譯后的運(yùn)行結(jié)果如下

?