qt5.1.1 mysql ubuntu QMYSQL driver not loaded

mysql, qt4, qt5.1, ubuntu

Solution

If you are Ubuntu linux OS, you can install library:

mic@ubt: ~$ apt-cache search libqt4-sql-mysql
libqt4-sql-mysql - Qt 4 MySQL database driver

mic@ubt: ~$ sudo apt-get install libqt4-sql-mysql

Problem

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(); } ```

Original source