Install mysql driver for qt in ubuntu

mkfnx

Yes, run qmake and make inside de MySQL Plugin Dir. That's how it worked for me.

doforumda

let me try to explain this now
what i did is remove ubuntu and install fresh ubuntu. then i install qt creator at home/zafar/qtsdk-2010.05 directory. then i did this
@
sudo apt-get install libmysqlclient15-dev
@
then i ran
@
qmake
@
command as it is described on this link
@
http://prres.wordpress.com/2010/05/17/configure-mysql-database-driver-for-qt/
@
After executing qmake command it displays this message
@
the program qmake can be found in the following packages
qt3-dev-tools
qt4-qmake
try sudo apt-get install <selected package>"
@
then i did "sudo apt-get install qt4-qmake" and it installs that package. then i run qmake command as describe in above link. it created Makefile in sqldrivers/mysql directory. everything went fine upto here but when i run make command it displays whole bunch of errors which i cannot type all those errors here.

DenisKormalev

So you have wrong qmake maybe. Add path to home/zafar/qtsdk-2010.05/qt/bin to PATH env variable (at the begining of it of course) and run qmake again.

doforumda

[quote author="Denis Kormalev" date="1286619015"]So you have wrong qmake maybe. Add path to home/zafar/qtsdk-2010.05/qt/bin to PATH env variable (at the begining of it of course) and run qmake again.[/quote]

ok i set variable by following steps here on "this link":http://www.zolved.com/synapse/view_content/28157/How_to_set_environment_variables_on_Ubuntu_

now my variable is $QTVAR = /home/zafar/qtsdk-2010.05/qt/bin. now i should go to this directory and run qmake or something else.

[edit: Link fixed / Denis Kormalev]

DenisKormalev

No, you've set the wrong env variable.
@
export PATH=/home/zafar/qtsdk-2010.05/qt/bin:$PATH
@
And after it run qmake in mysql plugin directory

doforumda

well i did that way then i run
@
qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib/mysql -lmysqlclient_r" mysql.pro
@

and then i run
@
make
@

so what should it display when i run make. i got q weird kind of output but i havent seen any errors kind of things.

DenisKormalev

Make itself outputs all steps of build. It shows you all compiling and linking operations it runs.

If make was successfull it should create libqmysql.so file which you should place into plugins/sqldrivers folder

doforumda

yes the libqmysql.so has been created and i copy it to the folder you specified. Now is it ready to use? can i start coding for in qt for mysql db?

DenisKormalev

Yes, all should be ok now. To check it just output content of
@
QSqlDatabase::drivers ()
@
QMYSQL should be there.

doforumda

thanks alot.

alittle more help will be appreciated. I have never used mysql in linux environment. I use it in windows by making web application in PHP. it is quit simple in windows because i just download wamp and install it and everything works perfectly i can create edit or delete databases and table through wamp very easily. i need alittle help here about how can i make database and tables in mysql in linux platform?

once again thanks alot for your help

DenisKormalev

You can either do it via console (by running mysql command) or you can install apache+php+phpmyadmin for web interface or you can install one of desktop GUI mysql clients.

doforumda

well when i run mysql command it says this
@
the program "mysql" can be found in the following packages:
mysql-client-core-5.1
mysql-client-5.0
mysql-cluster-client-5.1
try sudo apt-get install <selected-package>
@

which package should i install for creating databse

DenisKormalev

it depends on what server version do you have. You need client with same version.

doforumda

whatever we did in this thread it did not install mysql server? it installs mysql driver for qt?

DenisKormalev

Yes we've installed only driver for qt. If you want to store databases at your computer you need to install both mysql-server and mysql-client. If you will connect to remote database you can install only mysql-client.

doforumda

will it work if i install mysql server and client after installing mysql driver for qt? or if i install xamp then it will also work with qt. i am not using qt for web interface. i am using qt just to create desktop and mobile apps.

DenisKormalev

Yes it should work. For better compatibility install client with exactly same version as your installed dev packages.

doforumda

how would i know the version of my installed dev packages(by dev packages you mean which i installed for qt now).

and your reply "Yes it should work." means xamp will also work??

DenisKormalev

You SHOULD have mysql-server to be able to store and work with mysql databases at your computer.
Mysql-client is set of libraries and binaries which give access to mysql server (your or remote) for other applications or for you directly from console (mysql utility I'e mentioned before).
As I've seen earlier in thread you've installed mysql dev packages for mysql 5.0, so you need to install server and client versioned 5.0.

doforumda

ok i created a db "testTwo" in xampp. that db is in opt/lampp/var/mysql/testTwo folder. Now if i want to use this db then will code in my qt will get this db automatically when i provide QSqlDatabase db->setDatabaseName("testTwo"); or i need to copy this db somewhere else to make it available for qt?