QMysql Driver not loaded

[Cerberus]

When executing the following code I get an error that the Mysql driver is not loaded:

db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("127.0.0.1");
    db.setDatabaseName("test");
    db.setUserName("test");
    db.setPassword("test");
 
    if (!db.open()) {
        QMessageBox::critical(0, QObject::tr("Database Error"), db.lastError().text());
    } else
        qDebug() << "OPEN";

db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("127.0.0.1");
    db.setDatabaseName("test");
    db.setUserName("test");
    db.setPassword("test");

    if (!db.open()) {
        QMessageBox::critical(0, QObject::tr("Database Error"), db.lastError().text());
    } else
        qDebug() << "OPEN";

To copy to clipboard, switch view to plain text mode 

and in my .pro file I added it with

QT       += core gui sql

QT       += core gui sql

To copy to clipboard, switch view to plain text mode 

I'm using Ubuntu 15.10 and I have installed
libqt5sql5-mysql
libqt4-sql-mysql

and when locating them with I get

locate libqsql
/usr/lib/i386-linux-gnu/qt4/plugins/sqldrivers/libqsqlmysql.so
/usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqlite.so
/usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlite.so

locate libqsql
/usr/lib/i386-linux-gnu/qt4/plugins/sqldrivers/libqsqlmysql.so
/usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqlite.so
/usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlite.so

To copy to clipboard, switch view to plain text mode 

also when running the ldd command all dependencies can be found:

ldd libqsqlite.so 
	linux-vdso.so.1 =>  (0x00007fff631e6000)
	libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007f831f6d3000)
	libQt5Sql.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 (0x00007f831f691000)
	libQt5Core.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 (0x00007f831f1d4000)
	libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f831ee52000)
	libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f831ea88000)
	libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f831e869000)
	libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f831e665000)
	libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f831e44b000)
	libicui18n.so.55 => /usr/lib/x86_64-linux-gnu/libicui18n.so.55 (0x00007f831dfe7000)
	libicuuc.so.55 => /usr/lib/x86_64-linux-gnu/libicuuc.so.55 (0x00007f831dc53000)
	libpcre16.so.3 => /usr/lib/x86_64-linux-gnu/libpcre16.so.3 (0x00007f831d9f0000)
	libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f831d6e0000)
	librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f831d4d8000)
	libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f831d1d0000)
	libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f831cfb8000)
	/lib64/ld-linux-x86-64.so.2 (0x0000557933e71000)
	libicudata.so.55 => /usr/lib/x86_64-linux-gnu/libicudata.so.55 (0x00007f831b501000)
	libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007f831b293000)

ldd libqsqlite.so 
	linux-vdso.so.1 =>  (0x00007fff631e6000)
	libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007f831f6d3000)
	libQt5Sql.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 (0x00007f831f691000)
	libQt5Core.so.5 => /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 (0x00007f831f1d4000)
	libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f831ee52000)
	libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f831ea88000)
	libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f831e869000)
	libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f831e665000)
	libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f831e44b000)
	libicui18n.so.55 => /usr/lib/x86_64-linux-gnu/libicui18n.so.55 (0x00007f831dfe7000)
	libicuuc.so.55 => /usr/lib/x86_64-linux-gnu/libicuuc.so.55 (0x00007f831dc53000)
	libpcre16.so.3 => /usr/lib/x86_64-linux-gnu/libpcre16.so.3 (0x00007f831d9f0000)
	libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f831d6e0000)
	librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f831d4d8000)
	libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f831d1d0000)
	libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f831cfb8000)
	/lib64/ld-linux-x86-64.so.2 (0x0000557933e71000)
	libicudata.so.55 => /usr/lib/x86_64-linux-gnu/libicudata.so.55 (0x00007f831b501000)
	libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007f831b293000)

To copy to clipboard, switch view to plain text mode 

Do I need to do something else?

[creatron]

If you use QtCreator you need the mysql plugin. This is copied into the install directory
.... /plugins/sqldrivers

You need the following

libqsqlite.so
libqsqlmysql.so
libqsqlpsql.so

You can either create this with
[CODE]
cd $QTDIR/src/plugins/sqldrivers/mysql
qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysql -lmysqlclient_r" mysql.pro
make
[>CODE]
or just use QtCreator and open the above project files, and compile, it could moan and display a error message as one cannot run a plugin directly.
Now one just has to copy the created xx.so files into the plugin directory.

On Ubuntu , you may need to install the development environment with

sudo apt-get install libmysqlclient15-dev

sudo apt-get install libmysqlclient15-dev

To copy to clipboard, switch view to plain text mode 

[ChrisW67]

You seem to have three different Qt versions, 32 bit Qt4 and 64 bit Qt4 and Qt5. You need a consistent set of library of one "bitness". The Qt plugin for Mysql is already present for the basic 32bit Qt4 shown in the original post. These plugins are dependent on the Mysql runtime libraries (not part of Qt) that are likely not installed by default. You can check using ldd on the Mysql Qt plugin (not the Sqlite Qt plugin).

If needed, use something like this to install the Mysql client library

sudo apt-get install libmysqlclient15

sudo apt-get install libmysqlclient15

To copy to clipboard, switch view to plain text mode