Install mysql driver for qt in ubuntu

[DenisKormalev]

I've never worked with xampp, but if it has mysql server in it and this server is running then all should be ok.

[doforumda]

can you please check this thread i have some problem in loading mysql driver? "Your text to link here...":http://developer.qt.nokia.com/forums/viewthread/1208/

[swhweng]

Yet can't install according to above.
Why I get

@***Unknown option -lmysqlclient_r”@

when running

@qmake “INCLUDEPATH+=/usr/include/mysql” “INCLUDEPATH+=/home/paul01/QtSDK/Desktop/Qt/4.8.0/gcc/include/Qt” “LIBS+=-L/usr/lib/mysql -lmysqlclient_r” mysql.pro@

and next errors after make :

@paul01@paul01UbInsp:~/QtSDK/QtSources/4.8.0/src/plugins/sqldrivers/mysql$ make
g++ -c -pipe -O2 -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/usr/share/qt4/mkspecs/linux-g++ -I. -I/usr/include/qt4/QtCore -I/usr/include/qt4/QtSql -I/usr/include/qt4 -I/usr/include/mysql -I. -o main.o main.cpp
main.cpp:42:30: error: qsqldriverplugin.h: No such file or directory
main.cpp:43:25: error: qstringlist.h: No such file or directory
In file included from main.cpp:47:
../../../sql/drivers/mysql/qsql_mysql.h:45:30: error: QtSql/qsqldriver.h: No such file or directory
../../../sql/drivers/mysql/qsql_mysql.h:46:30: error: QtSql/qsqlresult.h: No such file or directory
In file included from main.cpp:47:
../../../sql/drivers/mysql/qsql_mysql.h:60: error: ‘QT_BEGIN_HEADER’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:70: error: expected class-name before ‘{’ token
../../../sql/drivers/mysql/qsql_mysql.h:77: error: ‘QVariant’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:84: error: ‘QVariant’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:86: error: ISO C++ forbids declaration of ‘QString’ with no type
../../../sql/drivers/mysql/qsql_mysql.h:86: error: expected ‘,’ or ‘...’ before ‘&’ token
../../../sql/drivers/mysql/qsql_mysql.h:89: error: ‘QVariant’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:90: error: ‘QSqlRecord’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:95: error: ISO C++ forbids declaration of ‘QString’ with no type
../../../sql/drivers/mysql/qsql_mysql.h:95: error: expected ‘,’ or ‘...’ before ‘&’ token
../../../sql/drivers/mysql/qsql_mysql.h:103: error: expected class-name before ‘{’ token
../../../sql/drivers/mysql/qsql_mysql.h:104: error: ISO C++ forbids declaration of ‘Q_OBJECT’ with no type
../../../sql/drivers/mysql/qsql_mysql.h:105: error: expected ‘;’ before ‘friend’
../../../sql/drivers/mysql/qsql_mysql.h:107: error: expected ‘)’ before ‘’ token
../../../sql/drivers/mysql/qsql_mysql.h:108: error: ‘QObject’ has not been declared
../../../sql/drivers/mysql/qsql_mysql.h:110: error: ‘DriverFeature’ has not been declared
../../../sql/drivers/mysql/qsql_mysql.h:111: error: ISO C++ forbids declaration of ‘QString’ with no type
../../../sql/drivers/mysql/qsql_mysql.h:111: error: expected ‘,’ or ‘...’ before ‘&’ token
../../../sql/drivers/mysql/qsql_mysql.h:118: error: ISO C++ forbids declaration of ‘QSqlResult’ with no type
../../../sql/drivers/mysql/qsql_mysql.h:118: error: expected ‘;’ before ‘’ token
../../../sql/drivers/mysql/qsql_mysql.h:119: error: ‘QStringList’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:120: error: ‘QSqlIndex’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:121: error: ‘QSqlRecord’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:122: error: ‘QString’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:124: error: ‘QVariant’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:125: error: ‘QString’ does not name a type
../../../sql/drivers/mysql/qsql_mysql.h:127: error: expected ‘:’ before ‘Q_SLOTS’
../../../sql/drivers/mysql/qsql_mysql.h:128: error: expected primary-expression before ‘bool’
../../../sql/drivers/mysql/qsql_mysql.h:128: error: ISO C++ forbids declaration of ‘Q_SLOTS’ with no type
../../../sql/drivers/mysql/qsql_mysql.h:128: error: expected ‘;’ before ‘bool’
../../../sql/drivers/mysql/qsql_mysql.h:136: error: ISO C++ forbids declaration of ‘QMYSQLDriverPrivate’ with no type
../../../sql/drivers/mysql/qsql_mysql.h:136: error: expected ‘;’ before ‘’ token
../../../sql/drivers/mysql/qsql_mysql.h:139: error: ‘QT_END_NAMESPACE’ does not name a type
main.cpp:60: error: ‘QMYSQLDriverPlugin’ has not been declared
main.cpp:60: error: ISO C++ forbids declaration of ‘QMYSQLDriverPlugin’ with no type
main.cpp: In function ‘int QMYSQLDriverPlugin()’:
main.cpp:61: error: only constructors take base initializers
main.cpp:63: warning: no return statement in function returning non-void
main.cpp: At global scope:
main.cpp:65: error: expected constructor, destructor, or type conversion before ‘’ token
make: *** [main.o] Error 1@

while having path set to
@
export PATH=/home/paul01/QtSDK/Desktop/Qt/4.8.0/gcc/bin:$PATH@

mysqlclient16-dev installed also .

???
Thanks in advance for help

[Skyrim]

An easy way to create a MySQL driver for Ubuntu 11.04, but the article in the Ukrainian language.
"this":http://aboutqt.blogspot.com/2011/10/mysql-qt-linux.html

[chandan]

Dear it is automatic giving in ubuntu...yesterday day installed it via ububtu software center and when I write the aboe code in console it gives me the followng output..
#include <QtSql>
int main(int argc,char * argv[])
{
QSqlDatabase db;
qDebug()<<db.drivers();
}
just added QT += sql in .pro file
<QSQLITE> <QMYSQL3> <QMYSQL>
hope..it will help full

[issam]

Try OpenSUSE 11.4 and you will never find any problem ! Qt will be installed and well configured with KDE desktop :)

OpenSUSE 11.4 : http://software.opensuse.org/114/en

[17elcapo]

the sdk. It doesn't exist.[/quote]

My friend try go in Qt Tools>Options>QtVersions>In Autodetected chose you Qt compiler>Look down click on Qt version 5 Details. Now look you PLUGINS folder and go. In sqldrivers folder check file libqsqlmysql.so exist and ins not protected.
If u not have this file download form Ubuntu software center searching libqt5 for QT5 or liqt4 for QT4 and install later copy the installed file /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers for 64bits machine or /usr/lib/i386-linux-gnu/qt5/plugins/sqldrivers for 32bits machine. to you plugins proyect folder
Sorry for my english regars from Argentina
[quote author="Denis Kormalev" date="1286470864"]By Qt instance I've meant directory where your Qt libraries lives.[/quote]