Qt--mysql问题

问题
Driver not loaded Driver not loaded

解决办法（重新编译 qsqlmysql.dll）
0.工程路径

C:\Qt\Qt5.10.1\5.10.1\Src\qtbase\src\plugins\sqldrivers\mysql

1.修改 mysql.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)

//此处添加mysql库的依赖
LIBS += -LD:/iristar/mysql-5.6.41-winx64/lib/ -llibmysql
INCLUDEPATH += D:/iristar/mysql-5.6.41-winx64/include
DEPENDPATH += D:/iristar/mysql-5.6.41-winx64/include

2. 修改 …/qsqldriverbase.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.构建，把编译好的库放到可在执行文件的路径下的sqldrivers里，并把libmysql.dll也拷贝过来

测试

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("127.0.0.1");//数据库服务器IP
db.setUserName("root");     //数据库用户名
db.setPassword("");         //密码
db.setDatabaseName("Sir");  //使用哪一个数据库
if (!db.open())            //数据库打开失败
{
	QMessageBox::warning(this, "open mysqldb", db.lastError().text());
	return;
}
QMessageBox::warning(this, "open mysqldb", "successful");