Error while compiling Qt mySQL driver

[mbnoimi]

Qt plugins really pain in the ass... I'm very frustrated!!!

It seems I've to rollback to Microsoft products after years of using Qt. Because of this stupid policy of Qt I always spend hours and hours on deployment or building a stupid plugin which suppose to be available in the binary distro!!!

Why the developer needs to rebuild anything from source code if he/she chose to use binary distro of Qt!!!

Any way, I filed a bug report about this stupid bug in this link:
https://bugreports.qt.io/browse/QTBUG-62078

For whom concern:
https://forum.qt.io/topic/81272/licenses-craziness

[Eduardo12l]

Have you qMake it?

[mbnoimi]

@Eduardo12l Yes

[Mohammad Kanan]

@All, You do not really need to rebuild the plugin! I guess you may get same error even after recompile.
Why: from the output, Qt creator, does not say there is any problem with QMYSQL, everything seems to be OK, except linking to the correct driver/lib, best to do is to try these steps first of all:

1. download the 32-bit version of mysql connector/c from:
   libmysql 32 bit version
   on Linux/Mac we get (mysql-connector-c-6.0.2-osx10.5-x86-32bit.tar)
2. untar, and install the package (with defaults), you should get the driver installed at :
   /usr/local/mysql-connector-c-6.0.2-osx10.5-x86-32bit/lib/libmysql.dylib
3. Then copy it to your build folder ( <your Base Qt location>/5.9.1/clang_64/bin) ... for test -> rebuild your solution and should not show that error again, plus, database connectivity should work.
   if it works then, instead of keeping the copied library at the qt bin directory, best is to remove it and add library to your project:
4. delete the file you copied to clang_64/bin .
5. in your project add library pointing to the downloaded 32 bit libmysql.dll (right click -> add library -> external)
   (adding as library is suitable later for deployment).

[mbnoimi]

Thanks a lot @Mohammad-Kanan your solution worked but I used mysql-connector-c-6.1.11-linux-glibc2.12-x86_64 instead of 32 bit version

I struggled with this issue for 15 days then I surrendered

[Mohammad Kanan]

@mbnoimi Good news! 32 or 64 bit depends on your system. I use Qt 32 bit on Win10, 64 bit, I don't know 64 bit one exists :) in my case the 64 bit lib didn't help.

[chrabaszcz.patryk]

Hi I had the same problem with qtsqldrivers-config.pri

I leave it here, maybe it will be helpful

Go to :
/Qt_new/5.9.1/Src/qtbase/src/plugins/sqldrivers
Run qmake:
../../../../../gcc_64/bin/qmake sqldrivers.pro
After that I got:

Configure summary:

Qt Sql:
DB2 (IBM) .............................. no
InterBase .............................. no
MySql .................................. yes
OCI (Oracle) ........................... no
ODBC ................................... no
PostgreSQL ............................. no
SQLite2 ................................ no
SQLite ................................. yes
Using system provided SQLite ......... no
TDS (Sybase) ........................... no

Then go to:
/Qt_new/5.9.1/Src/qtbase/src/plugins/sqldrivers/mysql
Run qmake again:
../../../../../../gcc_64/bin/qmake mysql.pro
Run make:
make
You will see as a part of an output message that it was compiled and moved into:
"mv -f libqsqlmysql.so ../plugins/sqldrivers/"

[yuzilong]

@chrabaszcz.patryk said in Error while compiling Qt mySQL driver:

Hi I had the same problem with qtsqldrivers-config.pri

I leave it here, maybe it will be helpful

Go to :
/Qt_new/5.9.1/Src/qtbase/src/plugins/sqldrivers
Run qmake:
../../../../../gcc_64/bin/qmake sqldrivers.pro
After that I got:

Configure summary:

Qt Sql:
DB2 (IBM) .............................. no
InterBase .............................. no
MySql .................................. yes
OCI (Oracle) ........................... no
ODBC ................................... no
PostgreSQL ............................. no
SQLite2 ................................ no
SQLite ................................. yes
Using system provided SQLite ......... no
TDS (Sybase) ........................... no

Then go to:
/Qt_new/5.9.1/Src/qtbase/src/plugins/sqldrivers/mysql
Run qmake again:
../../../../../../gcc_64/bin/qmake mysql.pro
Run make:
make
You will see as a part of an output message that it was compiled and moved into:
"mv -f libqsqlmysql.so ../plugins/sqldrivers/"

I try to solve this problem for the whole night,your solution saved me.Solve the problem perfectly. Thanks very much.Thanks .

[BeMind]

@chrabaszcz-patryk

Hi I had the same problem with qtsqldrivers-config.pri

I leave it here, maybe it will be helpful

Go to :
/Qt_new/5.9.1/Src/qtbase/src/plugins/sqldrivers
Run qmake:
../../../../../gcc_64/bin/qmake sqldrivers.pro
After that I got:

Configure summary:

Qt Sql:
DB2 (IBM) .............................. no
InterBase .............................. no
MySql .................................. yes
OCI (Oracle) ........................... no
ODBC ................................... no
PostgreSQL ............................. no
SQLite2 ................................ no
SQLite ................................. yes
Using system provided SQLite ......... no
TDS (Sybase) ........................... no

Then go to:
/Qt_new/5.9.1/Src/qtbase/src/plugins/sqldrivers/mysql
Run qmake again:
../../../../../../gcc_64/bin/qmake mysql.pro
Run make:
make
You will see as a part of an output message that it was compiled and moved into:
"mv -f libqsqlmysql.so ../plugins/sqldrivers/"

I had this problem when added Qt 5.13.0 using online installation to the Qt 5.12 i have already installed i thought the installation was wrong until i came across your solution. Thanks you very much.

[Cocojambo]

@chrabaszcz-patryk Registered here to thank you for your useful message :)

This problem is still actual in 5.15.0. Solved it as you mentioned.

[caha11]

@chrabaszcz-patryk Confirming this works, was trying to install ODBC and had the same error as OP. Did the suggested steps by @chrabaszcz-patryk and it worked on Qt 5.11.3 on Rpi 4B.