How to build Mysql driver with QT static build

AmrCoder

I tried to make a qt static version with MySQL build option so I used this to configure

-plugin-sql-mysql

it gives me an error and the MySQL in the summary file it marked by no so it's not working yet so I used this

-sql-mysql

for both, i got this error

ERROR: Feature 'sql-mysql' was enabled, but the pre-condition 'libs.mysql' failed.

so I tried this one

-qt-sql-mysql

i got this error

ERROR: Invalid value given for boolean command line option 'sql-mysql'.

so what command should i use to enable mysql to be built with my static version
Thanks in advance

Allerknappe

i have the same problem, the only solution that i found was that i use qt 5.7.1 instead a higher version and then it was working. maybe it works with higher version but i tried a few weeks and then i give up.

AmrCoder

hope that anyone tried this with a higher version to share this iam using QT 5.10 and I did not try the build static version before this

AmrCoder

when I was checking my question, by Coincidence I found the pinned post of How to create the plugin of MYSQL for Qt I check it and I follow some of his steps
i downloaded the MySQL community server and put it on C drive and rename the folder
that's all then in my configure command I add this to the end of my command

-sql-myself -I "C:\MySQL\include" -L "C:\MySQL\lib"

then I found in the summary folder that myself is marked by yes so I started built it then I test a simple MySQL connection with my static build it worked but I should include the .dll folder if not the app crashes I don't know if it's the right way to do this as I add .dll because the goal of the static build is to not use the DLL files it's only standalone app

SGaist

Then you have to also use static libraries for all the dependencies you want to use.