[QSqlQuery] Problem with not open database

[xkazielx]

Hi folks. I'm trying to write simple database program base on MySQL. I've established connection with database but I'can query. Here is what I'm talking about:

#include "myquery.h"
 
MyQuery::MyQuery(QWidget *parent)
    : QMainWindow(parent)
{
    db=QSqlDatabase::addDatabase("QMYSQL", "lge");
    db.setDatabaseName("WR");
    db.setHostName("localhost");
    db.setUserName("root");
    db.setPassword("password");
    using std::cout;
    if(db.open())
    {
        cout<<"Database opend.\n";
    }
 
    cout<<query.exec("SELECT * FROM items");
}

#include "myquery.h"

MyQuery::MyQuery(QWidget *parent)
    : QMainWindow(parent)
{
    db=QSqlDatabase::addDatabase("QMYSQL", "lge");
    db.setDatabaseName("WR");
    db.setHostName("localhost");
    db.setUserName("root");
    db.setPassword("password");
    using std::cout;
    if(db.open())
    {
        cout<<"Database opend.\n";
    }

    cout<<query.exec("SELECT * FROM items");
}

To copy to clipboard, switch view to plain text mode 

I'm trying to run this under WinXP. I've added "CONFIG+=console" to see std output and I'm getting:

Database opend.
QSqlQuery::exex:database not open
0

What I'm doing wrong?