QSqlDatabase: QMYSQL driver not loaded but available

[alexandrius]

Yeah hello there, I'm really new here.
So here's the problem.

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

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

To copy to clipboard, switch view to plain text mode 

I've checked many forums already and have done things so far:
1) This is my .pro file

QT       += core
QT       += sql
QT       -= gui
 
TARGET = DB
CONFIG   += console
CONFIG   -= app_bundle
 
QTPLUGIN += QSQLMYSQL
TEMPLATE = app
 
 
SOURCES += main.cpp

QT       += core
QT       += sql
QT       -= gui

TARGET = DB
CONFIG   += console
CONFIG   -= app_bundle

QTPLUGIN += QSQLMYSQL
TEMPLATE = app


SOURCES += main.cpp

To copy to clipboard, switch view to plain text mode 

2) This is my sqldrivers folder:

alex@alex-Laptop:~/Programming/Qt/5.1.0/gcc_64/plugins/sqldrivers$ ls
libqsqlite.so  libqsqlmysql.so  libqsqlpsql.so

alex@alex-Laptop:~/Programming/Qt/5.1.0/gcc_64/plugins/sqldrivers$ ls
libqsqlite.so  libqsqlmysql.so  libqsqlpsql.so

To copy to clipboard, switch view to plain text mode 

3) Have also copied sqldrivers folder to project folder.

Non of these helped an error still exists.
I have read almost everything about my problem but nothing helped.
Please help newbie with the fix.

Thanks in advance

[KillGabio]

post the part of the code where you open the database connection

[alexandrius]

QSqlDatabase db;
    db = QSqlDatabase::addDatabase("QMYSQL");
 
    db.setHostName("teachinglessons.abcz8.com");
    db.setPort(3306);
    db.setDatabaseName("teachi4_test");
    db.setUserName("alex");
    db.setPassword("123");
    qDebug()<<db.open();

QSqlDatabase db;
    db = QSqlDatabase::addDatabase("QMYSQL");

    db.setHostName("teachinglessons.abcz8.com");
    db.setPort(3306);
    db.setDatabaseName("teachi4_test");
    db.setUserName("alex");
    db.setPassword("123");
    qDebug()<<db.open();

To copy to clipboard, switch view to plain text mode 

[KillGabio]

Try giving the database a name:

db = QSqlDatabase::addDatabase("QMYSQL", "my_sql_db");

db = QSqlDatabase::addDatabase("QMYSQL", "my_sql_db");

To copy to clipboard, switch view to plain text mode 

Plus, have you built the plugins?

http://harmattan-dev.nokia.com/docs/...x-and-mac-os-x

[alexandrius]

Nothing change unfortunately

[KillGabio]

Read my editing, i think you are missing the step of building the plugins

[alexandrius]

Read my editing, i think you are missing the step of building the plugins

There's no /src/plugins/sqldrivers/mysql in my qt folder should i create it?

Sorry for stupid question

[KillGabio]

I have this path for example:

C:\QtSDK\QtSources\4.8.1\src\plugins\sqldrivers\my sqls

containing main.cpp, mysql.pro and readme.

Im running on windows, but you should have the same path i assume. Somewhere you need to have the files to generate and build your drivers.

[ChrisW67]

You have the Qt plugin for MySQL and it is recognised far enough to tell your program it exists. Are the MySQL run-time libraries (on which an actual database connection would depend) available on your machine?

[alexandrius]

KillGabio
There's nothing like that found in my Qt


ChrisW67
Yes but same problem

[KillGabio]

On Windows when I had the same problem i had to include the .dll of the database in this path:

C:\QtSDK\Desktop\Qt\4.8.1\mingw\plugins\sqldrivers

So that the compiler knows the libraries. For example there I have: qsqlite4.dll, qsqlocid4.dll, etc. I think you are missing the same files but for Unix (.so shared objects)