How could I connect to MYSQL server if that server do not allowed any remote access?

[anda_skoa]

Not necessarily.

It will mostly depend on the skill set of the involved people. If there are skilled PHP developers as well as skilled C++ developers each side should not have any problems maintaining their part.

Cheers,
_

[stereoMatching]

No, this is one option.

Additional to the web service approach already mentioned there is also the option of splitting the Qt application in frontend (client) and backend (server).
Or connecting through a VPN, an SSH tunnel, etc,

Cheers,
_

After google(VPN or SSH), the connection could become more secure, but the port still need to be opened
The admin worry that the server may suffer port attack if he open the port

Back to the php and c++, how could I use php as backend?
Create a QWebview, access the website, query the data by php, and show the data by Qt?

[sakya]

Create a QWebview, access the website, query the data by php, and show the data by Qt?

No.
Use QNetworkAccessManager to make the request to the server (GET or POST), read from QNetworkReply and parse the data returned (xml or json).

[stereoMatching]

No.
Use QNetworkAccessManager to make the request to the server (GET or POST), read from QNetworkReply and parse the data returned (xml or json).

According to your suggestions, we could
1 : use php to query, update db and generate xml or json
2 : use QNetworkAccessManager to post the request, ask the server generate json
and insert the data into the model
3 : update the data by posting request by QNetworkAccessManager

Maybe not so difficult.

[anda_skoa]

After google(VPN or SSH), the connection could become more secure, but the port still need to be opened

Open as in make MySQL listen for TCP connections or open as in open for outside connections?

Because the second is obviously not true, it would only allow internal connections in the VPN or SSH case.

You will always need some way to connect into your network, either through HTTPS, VPN or SSH.
The last two allow you to tunnel the database connection.

A fourth alternative is to use a SSL connection directly between a server component and a client component.

Cheers,
_

[stereoMatching]

Open as in make MySQL listen for TCP connections or open as in open for outside connections?

Because the second is obviously not true, it would only allow internal connections in the VPN or SSH case.

You will always need some way to connect into your network, either through HTTPS, VPN or SSH.
The last two allow you to tunnel the database connection.

A fourth alternative is to use a SSL connection directly between a server component and a client component.

Cheers,
_

Don't know what is the meaning of "open as in open for outside connections".
But I find this solution--http://stackoverflow.com/questions/1...-remote-access

Looks like there are more than one way to allow the computer of the local network to access the local server without open a port
1 : open as in open for outside connections(VPN or SSH)
2 : ssl
3 : use php to query and update db, Qt do another job