QT连接MySQL

一、编译MySQL源码

1、源码位置

Qt\Qt5.14.2\5.14.2\Src\qtbase\src\plugins\sqldrivers

2、源码修改

(1).pro

TARGET = qsqlmysql

HEADERS += $$PWD/qsql_mysql_p.h
SOURCES += $$PWD/qsql_mysql.cpp $$PWD/main.cpp

#QMAKE_USE += mysql

OTHER_FILES += mysql.json

PLUGIN_CLASS_NAME = QMYSQLDriverPlugin
include(../qsqldriverbase.pri)

LIBS += "C:\Program Files\MySQL\mysql-8.0.22-winx64\lib\libmysql.lib"

INCLUDEPATH += "C:\Program Files\MySQL\mysql-8.0.22-winx64\include"

DESTDIR  = ../mysql/myLib/

(2).pri

QT  = core core-private sql-private

# For QMAKE_USE in the parent projects.
#include($$shadowed($$PWD)/qtsqldrivers-config.pri)
include(./configure.pri)

PLUGIN_TYPE = sqldrivers
load(qt_plugin)

DEFINES += QT_NO_CAST_TO_ASCII QT_NO_CAST_FROM_ASCII

3、运行后

将qsqlmysql.dll文件放入kit的下列文件夹

Qt\Qt5.14.2\5.14.2\mingw73_64\plugins\sqldrivers

二、移动依赖

将下列文件夹中的libmysql.dll

MySQL\mysql-8.0.22-winx64\lib

移动至kit的下列文件夹

Qt\Qt5.14.2\5.14.2\mingw73_64\bin

注：以上内容为本人学习笔记记录，有借鉴网络上的内容，侵权麻烦联系我删除