Date: Thu, 20 Apr 2000 11:33:36 +0100 From: Adam Laurie <adam@algroup.co.uk> To: dan@langille.org Cc: freebsd-security@FreeBSD.ORG Subject: Re: using mysql over ssh Message-ID: <38FEDD00.6AF2E2FB@algroup.co.uk> References: <200004191926.HAA25058@ducky.nz.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?38FEDD00.6AF2E2FB>