From owner-freebsd-security Thu Apr 20 3:34:33 2000 Delivered-To: freebsd-security@freebsd.org Received: from eastwood.aldigital.algroup.co.uk (eastwood.aldigital.algroup.co.uk [194.128.162.193]) by hub.freebsd.org (Postfix) with ESMTP id 4046F37B5C3 for ; Thu, 20 Apr 2000 03:34:29 -0700 (PDT) (envelope-from adam@algroup.co.uk) Received: from algroup.co.uk ([192.168.192.2]) by eastwood.aldigital.algroup.co.uk (8.8.8/8.6.12) with ESMTP id KAA10119; Thu, 20 Apr 2000 10:33:42 GMT Message-ID: <38FEDD00.6AF2E2FB@algroup.co.uk> Date: Thu, 20 Apr 2000 11:33:36 +0100 From: Adam Laurie X-Mailer: Mozilla 4.7 [en-gb] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: dan@langille.org Cc: freebsd-security@FreeBSD.ORG Subject: Re: using mysql over ssh References: <200004191926.HAA25058@ducky.nz.freebsd.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-security@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Dan Langille wrote: > > > > Open two terminal windows... > > > > In window one, do: > > > > ssh -L 3306:localhost:3306 user@mydomain.org > > > > In window two, do: > > > > mysql -h localhost -u userid -p dbname < mysql.sql > > > > the mysql client will tunnel it's connection to the remote server, and you > > will be prompted locally for the password (if you're using an up to date > > copy of mysql). You can also use this method for an interactive session... > > > > You will need to have the remote server up to use MYSQL_TCP_PORT instead of > > the default MYSQL_UNIX_PORT, and it's a good idea to bind it to loopback to > > that only local or tunneled clients can connect. > > What is the point of two windows? The first one gives you an ssh tunnel. The second one uses the tunnel. > > Note: the goal is to put all of this into a script. It will not be interactive. > There will be nobody there to reply to a prompt. That's why I like the > ~/.my.cnf entry so much. I would go with that then. Just make sure it's owner-readable only. cheers, Adam -- Adam Laurie Tel: +44 (181) 742 0755 A.L. Digital Ltd. Fax: +44 (181) 742 5995 Voysey House Barley Mow Passage http://www.aldigital.co.uk London W4 4GB mailto:adam@algroup.co.uk UNITED KINGDOM PGP key on keyservers To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-security" in the body of the message