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
