From owner-freebsd-security Wed Apr 19 0:31: 5 2000 Delivered-To: freebsd-security@freebsd.org Received: from ducky.nz.freebsd.org (chilled.unixathome.org [203.79.82.27]) by hub.freebsd.org (Postfix) with ESMTP id 5039A37B6BD for ; Wed, 19 Apr 2000 00:31:02 -0700 (PDT) (envelope-from dan@langille.org) Received: from wocker (wocker.int.nz.freebsd.org [192.168.0.99]) by ducky.nz.freebsd.org (8.9.3/8.9.3) with ESMTP id TAA21657 for ; Wed, 19 Apr 2000 19:30:58 +1200 (NZST) Message-Id: <200004190730.TAA21657@ducky.nz.freebsd.org> From: "Dan Langille" Organization: langille.org To: freebsd-security@freebsd.org Date: Wed, 19 Apr 2000 19:30:34 +1200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: using mysql over ssh Reply-To: dan@langille.org In-Reply-To: X-mailer: Pegasus Mail for Win32 (v3.12b) Sender: owner-freebsd-security@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org > 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 There is nothing like finding the answer shortly after posting a question. I found the solution at: http://www.mysql.com/php/manual.php3?section=Password_security You create ~/.my.cnf and add this: [client] password=your_pass Then you don't need to specify the password on the command line as shown above. I'd still like feedback about my points 1 and 2 in my original post. cheers. -- Dan Langille [I'm looking for more work] http://www.langille.org/ | http://www.unixathome.org/ http://www.racingsystem.com/ | http://www.freebsddiary.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-security" in the body of the message