how to fix problem connecting to MYSQL using QT Creator

See more:

MySQL

Ubuntu

QT-Creator

I an learning QT creator. I found a sample program to connect to MYSQL. When I run it, I get these errors

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7

I have googled this for hours. Many suggest compiling the MYSQL plugin from scratch. I found the instructions didn't work. The path names were incorrect.

I am using Ubuntu 14.04 LTS. MYSQL version is 5.5.46-0ubuntu0.14.04.2.

QT creator version is 5.5.1. QT version 5.5.5

Here is the same qt project file
----------------------------------------------------------

QT       += core
QT       -= gui
QT       += webkit webkitwidgets
QT       += sql
TARGET = TestMySqlExample
CONFIG   += console
CONFIG   -= app_bundle


TEMPLATE = app

SOURCES += main.cpp

Here is the sample code
--------------------------------------------------------------------

#include <QCoreApplication>
#include <QApplication>
#include <QtSql/QSql>
#include <QtSql/QSqlDatabase>
#include <lQtSql/QSqlDriver>
#include <QtSql/QSqlQuery>
#include <QDebug>

bool createConnection();

int main(int argc, char *argv[])
{
    QApplication app(argc, argv);

    

    if (!createConnection()){

        qDebug() << "Not connected!";
        return 1;
    }
    else{

        qDebug() << "Connected!";

        QSqlQuery query;
        query.exec("SELECT Name FROM student");

        while (query.next()) {
            QString name = query.value(0).toString();
            qDebug() <<"name:" << name;
        }

        return 0;
    }

    return app.exec();
}
bool createConnection(){
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("mydb");
    db.setUserName("root");
    db.setPassword("moonpie");
    if (!db.open()) {
        qDebug() << "Database error occurred";
        return false;
    }
    return true;
}