QMYSQL driver not loaded on Ubuntu

[A Former User]

Well , I want to build mysql plugin for Qt 5.2 !
I get error message : QMySQL driver not found loaded.

I try test with a minimal code :

Main :

@
#include <QCoreApplication>
#include <QtSql/QSqlDatabase>
#include <QtSql>
#include <QDebug>

//remplacer l'affichage par la commande cout
#define q2c(string) string.toStdString()

int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
   db.setHostName("localhost");
   db.setDatabaseName("qtdatabase");
   db.setUserName("root");
   db.setPassword("");
   bool ok = db.open();

return a.exec();

}

@

and .pro :

@
#-------------------------------------------------

Project created by QtCreator 2014-01-01T09:22:46

#-------------------------------------------------

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

TARGET = untitled18
CONFIG += console
CONFIG -= app_bundle

QTPLUGIN += qsqlmysql
TEMPLATE = app

SOURCES += main.cpp

@

[SGaist]

Then use /opt/Qt5.2.0/path_to_bin/qmake to configure the plugin project

[A Former User]

[quote author="SGaist" date="1389260673"]Then use /opt/Qt5.2.0/path_to_bin/qmake to configure the plugin project[/quote]

I don't understand can you give me true and full command ? please :)

[SGaist]

rather that calling just qmake like you already did in the plugin folder, use the full path to /opt/Qt5.2.0/whatever_is_needed/bin/qmake and you should be good

[A Former User]

I have this path /opt/Qt5.2.0/5.2.0/gcc_64/bin/(qmake)

root@Gigabyte-Z68P-DS3:/opt/Qt5.2.0/5.2.0/Src/qtbase/src/plugins/sqldrivers/mysql# qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysql -lmysqlclient_r" mysql.pro

Project ERROR: addExclusiveBuilds() requires at least two arguments

I think my path is not true :( In Qt 4 i can build but in Qt 5.2 anything is different.

[SGaist]

use the full path:

@
root@Gigabyte-Z68P-DS3:/opt/Qt5.2.0/5.2.0/Src/qtbase/src/plugins/sqldrivers/mysql# /opt/Qt5.2.0/5.2.0/gcc_64/bin/qmake “INCLUDEPATH+=/usr/include/mysql” “LIBS+=-L/usr/lib/mysql -lmysqlclient_r” mysql.pro
@

[A Former User]

Sorry but gives follow message :

root@Gigabyte-Z68P-DS3:/opt/Qt5.2.0/5.2.0/Src/qtbase/src/plugins/sqldrivers/mysql# /opt/Qt5.2.0/5.2.0/gcc_64/bin/qmake “INCLUDEPATH+=/usr/include/mysql” “LIBS+=-L/usr/lib/mysql -lmysqlclient_r” mysql.pro
***Unknown option -lmysqlclient_r”
Usage: /opt/Qt5.2.0/5.2.0/gcc_64/bin/qmake [mode] [options] [files]

QMake has two modes, one mode for generating project files based on
some heuristics, and the other for generating makefiles. Normally you
shouldn't need to specify a mode, as makefile generation is the default
mode for qmake, but you may use this to test qmake on an existing project

Mode:
-project Put qmake into project file generation mode
In this mode qmake interprets files as files to
be built,
defaults to *; *; *; *.ts; *.xlf; *.qrc
Note: The created .pro file probably will
need to be edited. For example add the QT variable to
specify what modules are required.
-makefile Put qmake into makefile generation mode (default)
In this mode qmake interprets files as project files to
be processed, if skipped qmake will try to find a project
file in your current working directory

Warnings Options:
-Wnone Turn off all warnings; specific ones may be re-enabled by
later -W options
-Wall Turn on all warnings
-Wparser Turn on parser warnings
-Wlogic Turn on logic warnings (on by default)
-Wdeprecated Turn on deprecation warnings (on by default)

Options:

• You can place any variable assignment in options and it will be *
• processed as if it was in [files]. These assignments will be parsed *
• before [files]. *
  -o file Write output to file
  -d Increase debug level
  -t templ Overrides TEMPLATE as templ
  -tp prefix Overrides TEMPLATE so that prefix is prefixed into the value
  -help This help
  -v Version information
  -after All variable assignments after this will be
  parsed after [files]
  -norecursive Don't do a recursive search
  -recursive Do a recursive search
  -set <prop> <value> Set persistent property
  -unset <prop> Unset persistent property
  -query <prop> Query persistent property. Show all if <prop> is empty.
  -cache file Use file as cache [makefile mode only]
  -spec spec Use spec as QMAKESPEC [makefile mode only]
  -nocache Don't use a cache file [makefile mode only]
  -nodepend Don't generate dependencies [makefile mode only]
  -nomoc Don't generate moc targets [makefile mode only]
  -nopwd Don't look for files in pwd [project mode only]

[SGaist]

remove -lmysqlclient_r

[A Former User]

Yes , Solved !
Thank you dear :)

[SGaist]

You're welcome !

Now that you have the plugin, can you please update the thread title prepending [solved] so other forum users may know a solution has been found :)

[Malhar]

Hi SGaist,
i too faced this error and i did ldd libmysqlclient_r.so.16 and installed the dependency but still m getting this error QMYSQL driver not found available drivers QSQLITE.

[SGaist]

libmysqlclient_r.so.16 is the MySQL client library. What you should test is the Qt driver plugin. But based on available driver list, you don't have the MySQL plugin.

[Malhar]

@SGaist ok. Once i faced this problem and i solved installing dependency of .so file.
Now what should i do then.

[SGaist]

How did you install Qt ?

[Malhar]

using wget command "http://download.qt.io/archive/qt/5.1/5.1.0/qt-linux-opensource-5.1.0-x86_64-offline.run"

[SGaist]

You're aware that the current version is 5.5.1, aren't you ?

[Malhar]

yes i know about the latest version but my whole development is done on Qt5.1 so i dont want to change the version.

[SGaist]

Then you might have to build the plugin yourself.

[ram1111]

Hello SGaist i'm a beginner to Qt.

i get and installed Qt 5.7 in x64 edition for ubuntu.
I have QTPLUGIN += qsqlmysql and QT += sql in file .pro

when i try connect QMYSQL i got Error like :-
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QPSQL QPSQL7
QSqlError("", "Driver not loaded", "Driver not loaded")

when i do
itas02@itas02:/opt/Qt5.7.0/5.7/gcc_64/plugins/sqldrivers$ ldd libqsqlmysql.so
i got this
itas02@itas02:/opt/Qt5.7.0/5.7/gcc_64/plugins/sqldrivers$ ldd libqsqlmysql.so
linux-vdso.so.1 => (0x00007fff17fa3000)
libmysqlclient_r.so.16 => not found
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f379c377000)
libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007f379c13e000)
how to get libmysqlclient_r.so ?

when i try to build qmake
by
$:/src/plugins/sqldrivers/mysql# /home/../Qt5.7/5.7/gcc_64/bin/qmake “INCLUDEPATH+=/usr/include/mysql” “LIBS+=-L/usr/lib/mysql” mysql.pro
after entering make command

i'm getting like this

g++ -c -pipe -O2 -std=gnu++11 -fvisibility=hidden -fvisibility-inlines-hidden -D_REENTRANT -Wall -W -fPIC -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -I/opt/Qt5.7.0/5.7/gcc_64/include -I/opt/Qt5.7.0/5.7/gcc_64/include/QtSql -I/opt/Qt5.7.0/5.7/gcc_64/include/QtCore -I. -I/opt/Qt5.7.0/5.7/gcc_64/mkspecs/linux-g++ -o main.o main.cpp
In file included from main.cpp:44:0:
../../../sql/drivers/mysql/qsql_mysql.h:52:19: fatal error: mysql.h: No such file or directory
#include <mysql.h>
^
compilation terminated.
make: *** [main.o] Error 1

i have a mysql.h in /usr/include/mysql/

please let me know where i'm doing mistake are i missing any step.
thanks in advance

[SGaist]

How did you install the MySQL development package ?

And why are you using two different version of Qt ? You are inspecting one in /opt/ and you seem to be calling qmake from another install of Qt in your home folder.