QT编译mysql驱动

小灰灰 2022-12-27 07:36 156阅读 0赞

# Qt5.14.2用mysql8.x编译坑爹的mysql驱动 #

### mysql的下载地址：[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql] ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70][]

将下载的文件进行解压：D:\\mysql-8.0.22-winx64

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 1][]

### 在C:\\Qt\\Qt5.14.2\\5.14.2\\Src\\qtbase\\src\\plugins\\sqldrivers路径下： ###

找到![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 2][]

### 编辑mysql.pro： ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 3][]

TARGET = qsqlmysql
    
    HEADERS += $$PWD/qsql_mysql_p.h
    SOURCES += $$PWD/qsql_mysql.cpp $$PWD/main.cpp
    
    #QMAKE_USE += mysql
    win32:LIBS += -LD:/mysql-8.0.22-winx64/lib -llibmysql 
    
    INCLUDEPATH += D:/mysql-8.0.22-winx64/include
    
    DEPENDPATH += D:/mysql-8.0.22-winx64/include
    OTHER_FILES += mysql.json
    
    PLUGIN_CLASS_NAME = QMYSQLDriverPlugin
    include(../qsqldriverbase.pri)

### 构建mysql，并执行qmake： ###

C:\\Qt\\Qt5.14.2\\5.14.2\\Src\\qtbase\\src\\plugins\\build-sqldrivers-Desktop\_Qt\_5\_14\_2\_MinGW\_64\_bit-Debug\\plugins\\sqldrivers

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 4][]

### 将qsqlmysql.dll放入C:\\Qt\\Qt5.14.2\\5.14.2\\mingw73\_64\\plugins\\sqldrivers目录下， ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 5][]

### 将D:\\mysql-8.0.22-winx64\\lib下的libmysql.dll放入C:\\Qt\\Qt5.14.2\\5.14.2\\mingw73\_64\\bin目录下： ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 6][]

### 即可完成！！！ ###

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70]: /images/20221120/a5c1bd72daea48e084c1269713b0ac2e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 1]: /images/20221120/1ac27be1f5c24b18b1fef5efb7603864.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 2]: /images/20221120/cabd385da5244f15a3617db358235673.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 3]: /images/20221120/21194f0a561647229bed1e541be81133.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 4]: /images/20221120/7fb219afd691415199cc9a011b16775c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 5]: /images/20221120/60eebb6078d041d3820d6b0eb4e1ee10.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 6]: /images/20221120/9861a957de894050820b6ce8498a5684.png