Date: Thu, 20 Apr 2000 12:01:52 +0300 From: Camelia Nastase <camelia@office.banat.ro> To: Dan Langille <dan@langille.org> Cc: freebsd-security@FreeBSD.ORG Subject: Re: using mysql over ssh Message-ID: <38FEC780.24BC377B@office.banat.ro> References: <Pine.BSF.4.21.0004191550130.17472-100000@ducky.nz.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Dan Langille wrote: > > I want to access a mysql database remotely. I've had success with the > following approach: > > ssh user@mydomain.org /usr/local/mysql/bin/mysql -uuserid > -ppassword dbname < mysql.sql > > where mysql.sql contains the SQL statements I wish to run. > > I have two issues with this approach: > > 1 - The mysql password is supplied on the command line. I don't like > that. How can I avoid that? give yourself permissions to connect remotely ro the server, then mysql -h remote_host -u userid --password=<pass> dbname. that if you have mysql_client on the machine you work on. > > 2 - To achieve the ssh login, I copied the contents of ~/.ssh/identity.pub > to ~/.ssh/authorized_keys on the remote box. How much of a risk is it > allowing logins like that? My feeling is that if I trust the security on > the local box, it's not an issue. Comments? no comment on this. > > Any other suggestions/recommendations will be appreciated. > Camelia N. 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?38FEC780.24BC377B>