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

[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