QMYSQL database driver installation files

[babygal]

I want to use QMYSQL.
What are the driver installation files I need to install to work with my Qt4.6.2
and where can i get it?
Which version of QMYSQL I need to use ?
What are the procedures?

[saa7_go]

Read this guide.

[babygal]

int main(int argc, char *argv[])
{
 
    QApplication app(argc, argv);
 
    qDebug() << QSqlDatabase::drivers();
    if (!createConnection())
        return 1;
 
    Q_INIT_RESOURCE(cardiacprocessingtoolkit);
    MainWindow mainWin;
    mainWin.show();
 
 
    return app.exec();
}

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

    QApplication app(argc, argv);

    qDebug() << QSqlDatabase::drivers();
    if (!createConnection())
        return 1;

    Q_INIT_RESOURCE(cardiacprocessingtoolkit);
    MainWindow mainWin;
    mainWin.show();


    return app.exec();
}

To copy to clipboard, switch view to plain text mode 

The debug message reads as:
("QSQLITE", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC")

but the connection fails ! what's wrong?

[Lykurg]

but the connection fails ! what's wrong?

Show us how you connect to your database and look at the error message.

[babygal]

Show us how you connect to your database and look at the error message.

static bool createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("DatabaseName");
    if (!db.open()) {
        QMessageBox::critical(0, qApp->tr("Cannot open database"),
            qApp->tr("Unable to establish a database connection.\n"
                     "This example needs MYSQL support. Please read "
                     "the Qt SQL driver documentation for information how "
                     "to build it.\n\n"
                     "Click Cancel to exit."), QMessageBox::Cancel);
        return false;
    }
 
 
 
 
 
    return true;
}

static bool createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("DatabaseName");
    if (!db.open()) {
        QMessageBox::critical(0, qApp->tr("Cannot open database"),
            qApp->tr("Unable to establish a database connection.\n"
                     "This example needs MYSQL support. Please read "
                     "the Qt SQL driver documentation for information how "
                     "to build it.\n\n"
                     "Click Cancel to exit."), QMessageBox::Cancel);
        return false;
    }

 



    return true;
}

To copy to clipboard, switch view to plain text mode 

[saa7_go]

Can you connect to your MySQL server using MySQL client (mysql.exe) without username and password? Make sure your database "DatabaseName" exist and MySQL service is running.

[babygal]

Can you connect to your MySQL server using MySQL client (mysql.exe) without username and password? Make sure your database "DatabaseName" exist and MySQL service is running.

No I am not able to connect.I've no idea what's wrong.

[Lykurg]

Then probably you have to start your server!

[saa7_go]

In your previous post,

int main(int argc, char *argv[])
{
 
    QApplication app(argc, argv);
 
    qDebug() << QSqlDatabase::drivers();
    if (!createConnection())
        return 1;
 
    Q_INIT_RESOURCE(cardiacprocessingtoolkit);
    MainWindow mainWin;
    mainWin.show();
 
 
    return app.exec();
}

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

    QApplication app(argc, argv);

    qDebug() << QSqlDatabase::drivers();
    if (!createConnection())
        return 1;

    Q_INIT_RESOURCE(cardiacprocessingtoolkit);
    MainWindow mainWin;
    mainWin.show();


    return app.exec();
}

To copy to clipboard, switch view to plain text mode 

The debug message reads as:
("QSQLITE", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC")

Why do you look for libmysql.lib? You already have mysql plugin.

[babygal]

In your previous post,


Why do you look for libmysql.lib? You already have mysql plugin.

So what does that mean? I don't need the installation files?

confused.....

[saa7_go]

So what does that mean? I don't need the installation files?
confused.....

You don't need to rebuild QMYSQL plugin again, but you need MySQL server. Just, create(or use) a database, a table, inserting some record. Then, try to connect to mysql server using Qt, and see what happen(success or error).

[babygal]

You don't need to rebuild QMYSQL plugin again, but you need MySQL server. Just, create(or use) a database, a table, inserting some record. Then, try to connect to mysql server using Qt, and see what happen(success or error).

Do I need to do some configuration in my *.pro file to enable the MySql?

[saa7_go]

Do I need to do some configuration in my *.pro file to enable the MySql?

No, but you must add sql module in your .pro.

QT += sql

QT += sql

To copy to clipboard, switch view to plain text mode 

[babygal]

No, but you must add sql module in your .pro.

QT += sql

QT += sql

To copy to clipboard, switch view to plain text mode 

Thank you. I have added this line : QT += sql in my *.pro

The server is configured on another PC and my PC is supposedly the client. Does it make a difference in my code/project?

[saa7_go]

Does it make a difference in my code/project?

No. But, don't forget to set the correct hostname/ip where mysql server is installed.

[babygal]

Yayyy..Happy news ...it works ..my program can now connect to the mysql database on another server.
Thanks a million. and thanks for the patience replying my queries. Thanks!!!!

[babygal]

Read this guide.

In this guide, there is a prerequisite:
Download the MySQL installer (the essentials msi-package is enough) from MySQL.com and install it (make sure to choose to install the headers as-well.
But there are many downloads in that site MySQL.com . Which one do I choose?

[Lykurg]

take the MySQL Community Server. It will have all necessary files.

[babygal]

take the MySQL Community Server. It will have all necessary files.

i downloaded and installed : mysql-5.1.49 - win32.msi

[babygal]

I'm not able to execute the command 'reimp' as per the instruction in the link . And where can I get the download files for the reimp?

Goto the sub-directory lib/opt and run reimp libmysql.lib to produce the liblibmysql.a file. This is the import library to use with MinGW.