HOW to create QT5.6 & MySQL 5.7 DRIVER (HELP!) for QT Creator! For QT 5.6 MINGW 32 compiler

Ritskes · wrote on 3 May 2016, 09:59

Whatever I tried, I can NOT get the DRIVER working or made for QT5.6 with MySQL 5.7
All examples are with MySQL.PRO file, but this I can NOT find this at all.....
For both I have downloaded the communicty versions.

INFO:

QT 5.6
QT creator 3.6.1
MySQL 5.7
Windows 10
Database server up and running
My own project compiles and runs exept the driver

QT Run Message:
" QSqlDatabase: QMYSQL driver not loaded "

Tried many things, but I guess i'm doing something WRONG!

Just need to have a PROJECT that can access an EXISTING (MySQL) database where I can access tables and insert some fields that I extract from an CSV file. That part is already working and tested, But can NOT access any database due to the QSqlDatabase: QMYSQL driver not loaded thingy..

Help very much appreciated!!
(I can give emailadress mobile phone or even teamviewer to have this working)

Thanks in advance,
Ritskes

VRonin · wrote on 3 May 2016, 10:04

What OS are you running on?
Do you have qsqlmysql.dll deployed correctly?

"mobile phone or even teamviewer to have this working". Don't. Just DO NOT!

SGaist · wrote on 3 May 2016, 21:30

Hi and welcome to devnet,

One of the thing you have to do is to update the PATH environment variable in Qt Creator, in the Run part of the Project panel and add the path to your MySQL .dll files in it for Qt to find them.

Are you running a 32bit version of MySQL ?

On aside note, there's this old thread that might give you some clues if you need to rebuild the plugin.