Hi,
I have MySQL4.* and Apache2 running and have created a database called 'qttest' with a table 'test'. All files are locatet at
root@***:/var/lib/mysql/qttest# ll
insgesamt 24
-rw-rw---- 1 mysql mysql 65 2006-02-18 10:18 db.opt
-rw-rw---- 1 mysql mysql 8578 2006-02-18 10:19 test.frm
-rw-rw---- 1 mysql mysql 40 2006-02-18 10:19 test.MYD
-rw-rw---- 1 mysql mysql 1024 2006-02-18 10:19 test.MYI
root@***:/var/lib/mysql/qttest# ll
insgesamt 24
-rw-rw---- 1 mysql mysql 65 2006-02-18 10:18 db.opt
-rw-rw---- 1 mysql mysql 8578 2006-02-18 10:19 test.frm
-rw-rw---- 1 mysql mysql 40 2006-02-18 10:19 test.MYD
-rw-rw---- 1 mysql mysql 1024 2006-02-18 10:19 test.MYI
To copy to clipboard, switch view to plain text mode
So if I connet in Qt via the localhost of my running Apache all works fine.
db.setHostName("localhost");
db.setDatabaseName("qttest");
db.setUserName("root");
db.setPassword("");
bool ok = db.open();
[... SELECT ...]
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("qttest");
db.setUserName("root");
db.setPassword("");
bool ok = db.open();
[... SELECT ...]
To copy to clipboard, switch view to plain text mode
But how can I connect to the qttest.test table if no Apache and MySQL is running? What value I need for db.setHostName, and how tell I Qt to use the files in /var/lib/mysql/qttest?
Thanks
Lykurg
P.s.: SQLite is no alternative for me.
Bookmarks