QT连接MySQL_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

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