Is it possible to connect to mysql on another computer, in a different state? Is this secure? (could somebody intercept my username/password and gain access to my database?) Is it fast? Running a few small select statements and about 2 update/inserts? Most webhosts run php in safe mode, if it takes over 30 seconds for a script to execute, apache kills it. I'd need to be sure that my program could run in less time than that. Thanks for any help/feedback. Celia
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Remote Connection to Mysql 1
- Thread starter SCelia
- Start date
-
1
- #2
sleipnir214
Programmer
If the various firewalls between you and the MySQL server allow it, and if you have a username with sufficient permissions when connecting from your IP address, then it doesn't matter how much distance separates you from the database server.
MySQL does not encrypt any data going between the server and client, so it is not secure. I strongly recommend using some secure channel for the communication, such as VPN. I recommend NEVER exposing a database server to the general internet.
There are too many possibilities to be able to say how fast your connection will be. I can say that it will certainly be slower than connecting through your local networ. Want the best answers? Ask the best questions: TANSTAAFL!
MySQL does not encrypt any data going between the server and client, so it is not secure. I strongly recommend using some secure channel for the communication, such as VPN. I recommend NEVER exposing a database server to the general internet.
There are too many possibilities to be able to say how fast your connection will be. I can say that it will certainly be slower than connecting through your local networ. Want the best answers? Ask the best questions: TANSTAAFL!
- Thread starter
- #3
sleipnir214
Programmer
You can keep a database server protected from the general internet through the use of a firewall and the careful lockdown of any machine which communicates regularly with the internet through holes punched in that firewall.
VPN => Virtual Private Network.
A virtual private network connects two networks through by encrypting the data that goes between them.
There are other ways to protect data -- a dedicated wide area network is one idea. But VPN is by far and away the more affordable technology.
But this is not the forum for discussing the topic of VPNs. Want the best answers? Ask the best questions: TANSTAAFL!
VPN => Virtual Private Network.
A virtual private network connects two networks through by encrypting the data that goes between them.
There are other ways to protect data -- a dedicated wide area network is one idea. But VPN is by far and away the more affordable technology.
But this is not the forum for discussing the topic of VPNs. Want the best answers? Ask the best questions: TANSTAAFL!
- Thread starter
- #5
- Status