When I run the code QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 Database is Not Connected! Meet The Overflow, a newsletter by developers, for developers. Fascinating questions, illuminating answers, and entertaining links from around the web. Jun 14, 2014 How to create a 3D Terrain with Google Maps and height maps in Photoshop - 3D Map Generator Terrain - Duration: 20:32. Orange Box Ceo 7,906,773 views. Mar 29, 2016 Yeah hello there, I'm really new here. So here's the problem. QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7 I've checked many forums already and have done things so far: 1) This is my.pro file QT += core QT += sql QT -= gui.
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:
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:
What% of genes in a banana are found in us? Students should complete this work.Below we have 20 great pics on the subject of Cracking The Code Of Life Worksheet Answers. Please read this section and answer the questions on this worksheet.
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
C:Program Files (x86)MySQLMySQL Connector.C 6.1liblibmysql.dll
into to
C:QtQt5.3.15.3mingw482_32bin
2,67999 gold badges3333 silver badges5555 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:
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,90033 gold badges2222 silver badges3030 bronze badges
Nagaraj GaonkarNagaraj Gaonkar
Qmysql Driver Not Loaded Windows 8
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.
when deploying your app, copy libmysql.dll to the same directory as your .exe fileI hope this helps you same some time and frustration!
Qt Qmysql Driver Not Loaded Windows
Sam HighfieldSam Highfield
Qt Windows Qsqldatabase Qmysql Driver Not LoadedNot the answer you're looking for? Browse other questions tagged mysqlqt or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |