It is secure to access MySQL thru internet?
I need to access a database thru internet. It is secure to do this using MySql? Thanks Flavio Tobias
RE: It is secure to access MySQL thru internet?
Sure. If you use a secured connection. A$ -Original Message- From: Flavio Tobias [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:11 PM To: [EMAIL PROTECTED] Subject: It is secure to access MySQL thru internet? 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]
Re: It is secure to access MySQL thru internet?
What do you mean with secure connection, ssh? How to configure this on MySql? - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Flavio Tobias' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 29, 2003 2:17 PM Subject: RE: It is secure to access MySQL thru internet? Sure. If you use a secured connection. A$ -Original Message- From: Flavio Tobias [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:11 PM To: [EMAIL PROTECTED] Subject: It is secure to access MySQL thru internet? 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]
RE: It is secure to access MySQL thru internet?
Flavio, Sure. If you wanted to MySQL into a DB over the internet. I'd think ssh'ing would do the trick. This actually has nothing to do with MySQL, but allot to do with your OS. If you're running OS X, Linux, or some forms of Unix. SSH is probably a default package. Follow-up with the documentation for your OS. If its not available through the OS, you'll need some sort of 3rd party utility. Regards, Adam -Original Message- From: Flavio Tobias [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 3:53 PM To: Fortuno, Adam; [EMAIL PROTECTED] Subject: Re: It is secure to access MySQL thru internet? What do you mean with secure connection, ssh? How to configure this on MySql? - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: 'Flavio Tobias' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 29, 2003 2:17 PM Subject: RE: It is secure to access MySQL thru internet? Sure. If you use a secured connection. A$ -Original Message- From: Flavio Tobias [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:11 PM To: [EMAIL PROTECTED] Subject: It is secure to access MySQL thru internet? 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]
RE: It is secure to access MySQL thru internet?
I think your thinking of SSL. There is some work for mySQL that allows a sol connection and even some work to sol the replication over the net. Look for SSL on mysql.com ---Original Message- --From: Fortuno, Adam [mailto:[EMAIL PROTECTED] --Sent: Friday, August 29, 2003 12:59 PM --To: 'Flavio Tobias'; [EMAIL PROTECTED] --Subject: RE: It is secure to access MySQL thru internet? -- --Flavio, -- --Sure. If you wanted to MySQL into a DB over the internet. I'd think --ssh'ing --would do the trick. This actually has nothing to do with MySQL, but allot --to --do with your OS. If you're running OS X, Linux, or some forms of Unix. --SSH --is probably a default package. Follow-up with the documentation for your --OS. --If its not available through the OS, you'll need some sort of 3rd party --utility. -- --Regards, --Adam -- ---Original Message- --From: Flavio Tobias [mailto:[EMAIL PROTECTED] --Sent: Friday, August 29, 2003 3:53 PM --To: Fortuno, Adam; [EMAIL PROTECTED] --Subject: Re: It is secure to access MySQL thru internet? -- -- --What do you mean with secure connection, ssh? --How to configure this on MySql? -- --- Original Message - --From: Fortuno, Adam [EMAIL PROTECTED] --To: 'Flavio Tobias' [EMAIL PROTECTED]; [EMAIL PROTECTED] --Sent: Friday, August 29, 2003 2:17 PM --Subject: RE: It is secure to access MySQL thru internet? -- -- -- Sure. If you use a secured connection. -- -- A$ -- -- -Original Message- -- From: Flavio Tobias [mailto:[EMAIL PROTECTED] -- Sent: Friday, August 29, 2003 1:11 PM -- To: [EMAIL PROTECTED] -- Subject: It is secure to access MySQL thru internet? -- -- -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: It is secure to access MySQL thru internet?
Actually, Secure Shell is built on Secure Socket Layer. You generally speak of SSL with HTTPS connections. You can open an SSH session with a remote Unix box (or anything with an sshd running) then MySQL through that and it's encrypted. You can also create tunnels with SSH, but I've never done it. Gregory L. Hering 4807 Bradford Drive Huntsville, AL 35805 (256) 722-6420 -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 3:23 PM To: 'Fortuno, Adam'; 'Flavio Tobias'; [EMAIL PROTECTED] Subject: RE: It is secure to access MySQL thru internet? I think your thinking of SSL. There is some work for mySQL that allows a sol connection and even some work to sol the replication over the net. Look for SSL on mysql.com ---Original Message- --From: Fortuno, Adam [mailto:[EMAIL PROTECTED] --Sent: Friday, August 29, 2003 12:59 PM --To: 'Flavio Tobias'; [EMAIL PROTECTED] --Subject: RE: It is secure to access MySQL thru internet? -- --Flavio, -- --Sure. If you wanted to MySQL into a DB over the internet. I'd think --ssh'ing would do the trick. This actually has nothing to do with --MySQL, but allot --to --do with your OS. If you're running OS X, Linux, or some forms of Unix. --SSH --is probably a default package. Follow-up with the documentation for your --OS. --If its not available through the OS, you'll need some sort of 3rd party --utility. -- --Regards, --Adam -- ---Original Message- --From: Flavio Tobias [mailto:[EMAIL PROTECTED] --Sent: Friday, August 29, 2003 3:53 PM --To: Fortuno, Adam; [EMAIL PROTECTED] --Subject: Re: It is secure to access MySQL thru internet? -- -- --What do you mean with secure connection, ssh? --How to configure this on MySql? -- --- Original Message - --From: Fortuno, Adam [EMAIL PROTECTED] --To: 'Flavio Tobias' [EMAIL PROTECTED]; [EMAIL PROTECTED] --Sent: Friday, August 29, 2003 2:17 PM --Subject: RE: It is secure to access MySQL thru internet? -- -- -- Sure. If you use a secured connection. -- -- A$ -- -- -Original Message- -- From: Flavio Tobias [mailto:[EMAIL PROTECTED] -- Sent: Friday, August 29, 2003 1:11 PM -- To: [EMAIL PROTECTED] -- Subject: It is secure to access MySQL thru internet? -- -- -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
RE: It is secure to access MySQL thru internet?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 29 Aug 2003 15:59:18 -0400, Fortuno, Adam wrote: I need to access a database thru internet. It is secure to do this using MySql? If the database traffic is encrypted, yes. I do not know if that is an option in Mysql. If you did not do anything different when accessing the database locally vs. the Internet, then no, it is not secure. The traffic is basically in clear text. Other posts mention ssh (Secure SHell). That is a secure logon to the host where mysql resides and using the command window there. So that is a local connection and no need to encrypt (I would hope). Your interaction with the shell is encrypted. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/T7vhsxxMki0foKoRAiERAJ9gqttfaV1UMwF700/R6Ayx9VVZeACg5SVq 61Zuy4FtgBIUKjJvxfrDsws= =IHIg -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: It is secure to access MySQL thru internet?
We use a point to point VPN between server sites for this... so the security/encryption is totally transparent to mysql, it's just connecting to an IP address on tcp/3306 and the vpn appliances down the line deal with all the data security... There are cheaper solutions such as using freeswan, ssh port forwarding, etc.. But we have had great luck with vpn appliances which are getting very cheap nowdays... On Fri, 29 Aug 2003, Flavio Tobias wrote: 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]
RE: It is secure to access MySQL thru internet?
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]
Re: It is secure to access MySQL thru internet?
Flavio Tobias wrote: I need to access a database thru internet. It is secure to do this using MySql? Sure. If you use a secured connection. What do you mean with secure connection, ssh? How to configure this on MySql? I'ld think about SSL http://www.mysql.com/doc/en/Secure_basics.html Use show variables like '%ssl%' to see if it is enabled on your server. For Windows2Windows you might consider IPsec. HansH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
