After build and install MySql driver for Qt it's unable to load the MySql Drive

[Malibob]

I'm already build and install the MySql drive like
But still I got the error message QMYSQL driver not loaded. Now it;s say MySql as a available driver. I'm using 64bit windows, Qt creator version 32-bit, mingw81_64 and MySql 64 bit Error is,

" QMYSQL driver not loaded. available drivers: QSQLITE QMARIADB QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7"
How can I solve this?

[jsulm]

@Malibob In the screen shot you did not build and install anything. You only called qmake. Did you also call make/make install?

[Malibob]

This post is deleted!

[Malibob]

@jsulm
Yes I did make/make install. If any problem in MySql version?

[jsulm]

@Malibob You can use https://www.dependencywalker.com/ to check whether something is missing for the MySQL plug-in DLL.

[Malibob]

@jsulm
I'm using 64bit windows, Qt creator version 32-bit, mingw81_64 and MySql 64 bit. What are the .dll s that i want to use and where? I'm confused with this .dll stuff

[JSher]

Your mysql driver has to be accessed by the compiler you are using. Put it in the bin directory of mingw

--James

[Malibob]

@JSher Thank you for reply. Did You mean put libmysql.dll and libmysql.lib in to mingw's bin? it doesn't work. I'm new to programming. So this may be silly question

[JSher]

I would download mysql connector 6.1(last one with prebuilt libmysql.dll and use it to be sure you did not mess up the build.

If that does not work open creator, click projects on left side, switch top to debug and add a Build Environment entry called QT_DEBUG_PLUGINS and set it to 1. Then run in debug mode and read through the module load trace to see where it is loading what module from and whether it is able to load what it is looking for.

--James

[jsulm]

@JSher said in After build and install MySql driver for Qt it's unable to load the MySql Drive:

Your mysql driver has to be accessed by the compiler you are using. Put it in the bin directory of mingw

What?!
This is not necessary at all!

[jsulm]

@Malibob Open qsqlmysql.dll in DependencyWalker and see whether something is missing (especially the MySQL client lib).

[Malibob]

@jsulm Ther is no qsqlmysql.dll anywhere

[jsulm]

@Malibob There is - in your Qt installation: on my machine it is in c:\Qt\5.11.1\mingw53_32\plugins\sqldrivers

[Malibob]

@jsulm I got this.
Is it make any sence

[jsulm]

@Malibob From that screen-shot I can't say. Please collapse all MS DLLs. Especially check whether the MySQL client lib is found.

[Malibob]

@jsulm There is no MySQL client lib collapse