Connection to a MySQL database with Qt Creator on Windows

[Advanced]

@Justin_Ahinon said in Connection to a MySQL database with Qt Creator on Windows:

QMYSQL

Hi
Did you try with fresh install of Qt?

[Justin_Ahinon]

@Advanced
No.
But I've uninstalled and reinstalled Qt.

This night, I'll install the new Qt 5.10 and try again.

Thanks.

[Advanced]

It's probably fixed your issue, but i recommend to you if you want to sure about stability used latest LTS version of Qt that it's 5.9.3

[Stoyan]

@Justin_Ahinon
If this error occurred also with SQLITE, then check if you have in your *.pro file something like this:

QT += sql

[SGaist]

Hi,

To add to my fellow, do you have the MySQL client libraries available on your system ?

[Justin_Ahinon]

@SGaist
Yes, I think

[SGaist]

Run your application with the QT_DEBUG_PLUGINS environment variable set to 1 to see what is happening.

You can set that variable in the Run part of the project panel.

[Sunfluxgames]

I would make sure you complie the mysql plugin..

1. make sure you have installed mysql the same lib headers for x86 or x64.
2. open mysql plugin located in qbase you will have to comment out a few things as they still havnt fix the bug yet.
3. copy those libs and dlls into your complier folder
4. copy mysqlclient.dll and qt5sql.dll into your .exe folder
5. should be all set...

[Justin_Ahinon]

Hi every body,
I solve the problem by using the QSQLITE driver which is installed with Qt.

/.pro file
QT += widgets sql

//.cpp file
bool createConnection()
{
    QSqlDatabase laBase = QSqlDatabase::addDataBase("QSQLITE");
    laBase.setHostName("localhost");
    laBase.setDataBaseName("test");
    laBase.setUserName("justin");
    laBase.setPassword("******");

    if (!laBase.open()){
       QMessageBox:: critical (0 /* ... */ );
       QObject::tr("Error"), 
       laBase.lastError().text());
       return false;
    } 
    return true; 
}

[SGaist]

Hi,

Are you aware of the implications of moving from MySQL to SQLite ?

One of which is: you are using a relative path for your SQLite database which won't work if your users install your application in e.g. Program Files as it's a read-only location.