Mysql unknown database, QMYSQL unable to connect

[lixo1]

Dear all,

I just downloaded Qt 4.6.1 installer for windows (VC++ 2008), and I would like to create and use QMYSQL.
I tried all sql examples with QSQLITE and they worked, then I downloaded MySql 5 installer, I built the *.dll qt plugin,
but I can't open/create a new database from scratch.
My code is the following:

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setUserName("root");
    db.setPassword("pass");
    db.setDatabaseName("test.mysql"); //I would like to create a new database, locally on my pc
    if (!db.open())  return false;

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setUserName("root");
    db.setPassword("pass");
    db.setDatabaseName("test.mysql"); //I would like to create a new database, locally on my pc
    if (!db.open())  return false;

To copy to clipboard, switch view to plain text mode 

And I'm getting: Unknown database 'test.mysql' QMYSQL: unable to connect.

Any kind of help is appreciated,
Thank you very much.

[Lykurg]

You have to exec an valid SQL statement to create a new database, afterwards you can set it.

CREATE DATABASE foo;

CREATE DATABASE foo;

To copy to clipboard, switch view to plain text mode 

[saa7_go]

If you use QMYSQL driver,

db.setDatabaseName("db_name");

db.setDatabaseName("db_name");

To copy to clipboard, switch view to plain text mode 

means open existing database.

You can create database using QSqlQuery.

QSqlQuery query("CREATE DATABASE db_name");

QSqlQuery query("CREATE DATABASE db_name");

To copy to clipboard, switch view to plain text mode 

[lixo1]

Thank you very much!