That seems like a lot of work to do when mysql has it built in. http://www.mysql.com/doc/en/Secure_basics.html
4.3.9.1 Basics Beginning with version 4.0.0, MySQL has support for SSL encrypted connections. To understand how MySQL uses SSL, it's necessary to explain some basic SSL and X509 concepts. People who are already familiar with them can skip this part. -->-----Original Message----- -->From: Cal Evans [mailto:[EMAIL PROTECTED] -->Sent: Friday, August 29, 2003 1:39 PM -->To: Flavio Tobias -->Cc: [EMAIL PROTECTED] -->Subject: Re: It is secure to access MySQL thru internet? --> -->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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
