Accessing MySQL database from C++

Question

I want to connect to a MySQL database from a Qt C++ application. Database is located on a host and is available on internet. I have the MySQL username, password and IP of host and a port number (that I don't know what is)

    Application::getInstance()->db = QSqlDatabase::addDatabase("QMYSQL");
    QSqlDatabase *db = &Application::getInstance()->db;
    db->setHostName("64.34.119.12");    // The string is IP address of my host (not real) 
    db->setDatabaseName("foo");
    db->setUserName("root");
    db->setPassword("password");
    db->open(); // returns false

I tried to pass IP address to db->setHostName() but not worked: Connection fails.

This code works with local database. I want to change it to work with online database (same as local one). — Soroush Rabiei
– Soroush Rabiei, Commented Jul 10, 2011 at 16:20
You need to find our the port number and ensure the firewall isn't blocking it. Easy way is to try and telnet into the ip/port to determine if a connection can be made. If not then it's very likely a firewall issue. — Andrew T Finnell
– Andrew T Finnell, Commented Jul 10, 2011 at 16:40

HalloDu · Accepted Answer · 2011-07-10 16:31:54Z

4

Well, because you gave very little information, I cannot give you anything but a hunch, so here I go: Often webhosters configure there MySQL Databases to only accept connections from localhost (for a php or similar site, that is locate there, that's enough and that way it is more secure and abuse is less likely). That could be the reason why a connection from your machine is not accepted, though you have the right credentials.

answered Jul 10, 2011 at 16:31

HalloDu

9071 gold badge7 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Soroush Rabiei Over a year ago

I want my database to be available to all clients over internet. so I add record '%.%.%.%' on remote database access control of CPanel. I'm not sure if this is true or not ...

Thomas Vincent Over a year ago

@Sorush: did you at least try to access your database from a remote client with an other tool ? Just to confirm credentials issues are not the problem here ...

Soroush Rabiei Over a year ago

I tried with MySQL admin and Query Browser, but any of them didn't connect.

Collectives™ on Stack Overflow

Accessing MySQL database from C++

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related