Qmysql Driver Not Loaded Windows

Qt database connection: QMYSQL driver not loaded. Can be placed anywhere the standard Windows DLL search would look when it loads the plugin dll (on a dev machine. I run ubuntu 14.04 and i installed Qt4 and Qt5. I have created and implemented a project in Qt5 ( specifically: Based on Qt 5.4.1 (GCC 4.6.1, 32 bit) ). I try in my programm to make connection to a database ( ΜySql ) but I can not. Aug 06, 2013  The results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.

Active11 months ago

My program is write with QT5.2 and use mysql. I heared that QT5.2 contains MYSQL driver already. However, when I compile and run my program, it is compiled successfully but runned failed with error:

Reload creator and voila your mysql driver is perfectly loaded; So basically for those who want to understand what happened here: That 'qsqlmysql' plugin is basically a qt interface that uses mysql-C connector methods. But unfortunately this connector does not distributed with Qt, so you should provide it by yourself. I am trying to implement a database system in my Qt application. For this purpose, I am trying to use MySQL (with the related QMYSQL driver). My class connection-function is written below. Why QMYSQL driver not loaded in QT5.2? Ask Question. QMYSQL driver not loaded on windows 10. MySQL + Qt QMYSQL plug-in = commercial MySQL license?

My programe is like this:

And in .pro I add this:

Mysql is provided by XAMPP.My OS is win7-x64-sp1-ultimate, and XAMPP Version 1.8.2.System Path is as follow:

XAMPP location is :

QT location is:

I have installed mysql server-5.6-64bit in D:SoftwareMySQL, and when it conflicted with mysql in XAMPP, I uninstalled mysql server-5.6-64bit.

huaxz1986huaxz1986

5 Answers

I met with the same error and fixed it successfully by copying file

Qsqldatabase Available Drivers

C:Program Files (x86)MySQLMySQL Connector.C 6.1liblibmysql.dll

into to

C:QtQt5.3.15.3mingw482_32bin

Ram
2,6799 gold badges33 silver badges55 bronze badges
Hồ Sĩ SơnHồ Sĩ Sơn

I was facing the same issue and even 'Hồ Sĩ Sơn's solution didn't work. I then found out that I had installed a 64-bit version of MySQL and was trying it on a 32-bit version of Qt.

Copying the dll from the below location didn't work:

Instead download the 32-bit version of libmysql.dll from:

and the copy it to your mingw folder.

In my case, I had to copy the DLL to msvc2010 folder since I am using Visual Studio compiler:

Works without an internet connection. Available as a portable application. Device identifier download.

Hope this helps. :)

medasumanthmedasumanth

Adding post due to reputation deficit.

I was able to resolve my issue using a combination of Hồ Sĩ Sơn, Ram, and Sumanth's posts (Thank you both).

Here are my exact steps:

Checked the version of Qt Creator that I am running by visiting Help -> About Qt Creator. I found that I am running the 32-bit version.

Now that I know what version I am running I navigated to the 32-bit version of the MySQL connector. This was found in C:Program Files (x86)MySQLMySQL Connector C 6.1lib.

I copied the libmysql.dll file found in that folder, and pasted it into C:Qt5.9.2mingw53_32bin since I am compiling with MinGW. Note that this is the 32-bit folder.

Restarted Qt Creator and rebuilt my project.

The steps that were challenging me were matching the x-bit version of Qt Creator, my compiler, and the driver, then restarting Qt Creator.

Hope this helps someone out there!

Jeramy D.Jeramy D.

I faced the same issue and resolved by below steps.

By doing 6 hours of research finally issue is resolved. I was using 64 bit windows 10, 32 bit Qta and 64 bit MySQL server.

QSQLITE and QODBC was working perfectly, but faced issue with QMYSQL.

Later I have downloaded 'mysql-connector-c-6.1.11-win32.zip' (if it is 32 bit QT)from https://dev.mysql.com/downloads/connector/c/ copied 'libmysql.dll' to QT path C:Qt5.9.3mingw53_32bin.

Wow. it was working perfectly.

Avag Sargsyan
1,9003 gold badges22 silver badges30 bronze badges
Nagaraj GaonkarNagaraj Gaonkar

Qt Driver Not Loaded

I also spent about 2 days on this problem, here's how I solved it:

My setup:64 bit Windows 10QT 5.11.1 and QT Creator 4.7.1 32 bitBuilding a 64 bit app..

Download this zip file: mysql-connector-c-6.1.11-winx64.zipfrom this website:https://downloads.mysql.com/archives/c-c/

copy this file:C:.mysql-connector-c-6.1.11-winx64.zipmysql-connector-c-6.1.11-winx64liblibmysql.dll

into this directory:C:Qt5.11.1msvc2015_64bin

Note: change 'msvc2015_64' to whatever compiler you are using, though it needs to be 64 bit.

Qmysql Driver Not Loaded Windows 7

when deploying your app, copy libmysql.dll to the same directory as your .exe fileI hope this helps you same some time and frustration!

Sam HighfieldSam Highfield

Qsqldatabase Qmysql Driver Not Loaded Windows 7

Not the answer you're looking for? Browse other questions tagged mysqlqt or ask your own question.