qt5.1.1 mysql ubuntu QMYSQL driver not loaded

Rsvay picture Rsvay · Jan 31, 2014 · Viewed 9.6k times · Source

I'm trying to access mysql using Qt5.1.1 but i am getting the error the error below. I also searched a lot on google but unable to fix it.Please suggest me a solution so that i am able to resolve this error.

error:

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3
QSqlError(-1, “ driver not loaded”, “ driver not loaded”)

code:

#include <QCoreApplication>
#include <QDebug>
#include <QDir>
#include <QtSql>
#include <QSqlDriver>
#include <qsqldatabase.h>
#include <QSqlError>
#include <QPluginLoader>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QSqlDatabase db= QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("NNF");
    db.setUserName("root");
    db.setPassword("root123");
    if( !db.open() )
    {
        qDebug() << db.lastError();
        qFatal( "Failed to connect." );
    }

    qDebug( "Connected!" );
    return a.exec();
}

Answer

Crisferlop picture Crisferlop · Nov 5, 2014

Well, for Qt5 you need install MySQL, using the next command on the terminal, you resolve the problem:

sudo apt-get install libqt5sql5-mysql