As stated before, it is possible via ssh. This assumes 2 things: 1: Your client machine is windows 2: Your server is running a ssh server. (Which USUALLY means it's a flavor of Unix but there are ssh servers for windows...why, I don't know but there are.)
First, grab putty. Putty is a ssh client on windows. To make putty work you will need a shell account on the server running MySQL. If you don't have that, stop reading now because none of this will work if putty won't connect. http://www.putty.nl/download.html Next grab SQLYog. yes, there are other windows clients for MySQL. Some of them are even free. I've used just about every one and SQLYog is the best. Anyhow, for the purposes of this message, grab the 30 day trial version. You can decide for yourself if you want to buy it. http://www.webyog.com/ Now, here's a tutorial for setting up a tunnel in putty. MySQL runs on 3306 usually. You will need the name or IP address of the machine running the MySQL server. http://www.cyberknights.com.au/doc/PuTTY-tunnelling-HOWTO.html Once you can connect putty to the server and you have the tunnel built, fire up SQLYog and setup a connection. NOTE: MySQL host address is localhost because you are talking to your tunnel, not the server. That's all there is. Now you have a safe and encrypted tunnel to MySQL. HTH, =C= * * Cal Evans * http://www.eicc.com * We build IT solutions * Flavio Tobias said: > I need to access a database thru internet. It is secure to do this using > MySql? > > > Thanks > Flavio Tobias > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
