From: Hans Date: October 17 1999 9:34pm Subject: Re: connection to other servers List-Archive: http://lists.mysql.com/java/374 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Hi Cris, On 17-Oct-99 Cris Perdue wrote: >> Is there a way to use ssh when making a connection to another mysql server? >> > Yes. Learn how to set up "port forwarding" with SSH. Set up a port on your > client machine that forwards to MySQL's port on the remote server. Establish > an SSH session between the machines, and MySQL will work fine over this > connection. Your app connects to the port set up on the machine near it, and > all traffic passes to the port on the remote machine, and back. This might be usefull, I will have to make a connection to at least 2 other MySQL servers and was looking for the best way to do it. > I have used such a setup for some time now, in my case from a client PC > running VanDyke's SecureCRT product to a Linux box running sshd. Of course > you may find performance issues depending on the speed of the link and the > rate your systems can encrypt and decrypt data. Speed isn't an issue. I think that about 10 connection's a day will be all, I think I will be able to make a user interface which will update the database to one mysql-server and let the client update the other servers. Thanks, Hans -- Linux / Com21 / CMI8330 / FAQ / Linux search http://linux.gelrevision.nl/index.shtml 11:25pm up 21 days, 12:46, 3 users, load average: 0.01, 0.03, 0.04