Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Reaching a remote MySQL database via DSN?

Reaching a remote MySQL database via DSN?

Reaching a remote MySQL database via DSN?

Hi All,

 I have a problem that is probably a very simple one for those who use it in their daily work, however I could not find a good answer yet.
 We have an ASP program that runs a project management software under MySQL database and Windows 2003. We have clients who have concerns to keep their private business information on our server and since they have their own machines, they want to host the application as well. We do not want to give out our program source code either, plus it makes updates really hard if we have a couple different hosts.

 So I figured the best way to resolve this: We let the sensitive business information kept on our client's server, while we keep our software on our machine and just reach out remotely to the client whenever data is needed or changed. I thought it is easy to do by configuring a DNS on the server we have the program pointing to the remote machine and use the DNS to connect... BUT it does not work for me. Probabaly because of some security settings on MySQL? Does anybody have a generic, step by step instruction how I can get this to work? As I am setting up a DSN, it let me type in an IP address as well, but I can not test the database and I have no clue what password it would expect...
Is this something that I should use a VPN, so the data transactions between the servers are safe?

Any help would be appreciated...

RE: Reaching a remote MySQL database via DSN?

The MySQL server username will have to be set to allow connections from the client IPs or from wildcard hosts and wildcard is NOT recommended as something you should do.

But surely as an ASP program the clients connect using a browser and simply get a HTML page with the data.

If you want to encrypt the communications and data transfer all you need to do is create a self-signed SSL certificate and the clients access the data via https.


Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close