From owner-freebsd-database Sat Nov 2 20:30: 5 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8E99037B401 for ; Sat, 2 Nov 2002 20:30:03 -0800 (PST) Received: from h24-68-7-184.vc.shawcable.net (h24-68-7-184.vc.shawcable.net [24.68.7.184]) by mx1.FreeBSD.org (Postfix) with ESMTP id A842043E88 for ; Sat, 2 Nov 2002 20:30:02 -0800 (PST) (envelope-from freebsd@patrickg.com) Received: from [24.68.7.184] (localhost [127.0.0.1]) by h24-68-7-184.vc.shawcable.net (8.12.2/8.12.2) with ESMTP id gA34TtVC024465 for ; Sat, 2 Nov 2002 20:29:56 -0800 (PST) User-Agent: Microsoft-Entourage/10.1.0.2006 Date: Sat, 02 Nov 2002 20:29:52 -0800 Subject: Re: MySQL Password not masked in process listings From: patrick gibson To: Message-ID: In-Reply-To: <000101c282e1$19ab3ba0$c905010a@daylight.net> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On 11/2/02 18:31, John Brooks wrote: > use "-p" without a password, you will be prompted for it and the > ps listing will not be displaying it then I know I can do this -- but if I have a script which needs to connect to the database, I would like to be able have a non-interactive connection. I'm also aware that one can specify usernames and passwords in the ~/.my.cnf file, but I connect to different databases with different passwords, so that way would not really work for me either. I'm just wondering if anyone has noticed this difference between running MySQL on FreeBSD and Linux. Patrick >> -----Original Message----- >> From: owner-freebsd-database@FreeBSD.ORG >> [mailto:owner-freebsd-database@FreeBSD.ORG]On Behalf Of patrick gibson >> Sent: Saturday, November 02, 2002 2:07 PM >> To: freebsd-database@freebsd.org >> Subject: MySQL Password not masked in process listings >> >> >> I've been noticing that in FreeBSD, when I run the MySQL client with a >> password specified on the command line (eg. mysql -pMyPassword MY_DATABASE), >> the password is not masked when I (or any other user!) issue a "ps" or "w" >> command. >> >>> patrick 47724 ... 11:49AM 0:00.03 mysql -pMyPassword MY_DATABASE >> >> I recently switched from Linux, and somehow it knew to mask >> the password: >> >>> patrick 47724 ... 11:49AM 0:00.03 mysql -p******* MY_DATABASE >> >> Does anyone know if this is a FreeBSD issue, or is it a problem in the way >> that MySQL is compiled for FreeBSD? >> >> Thanks in advance, >> >> Patrick ---| patrick gibson |---------------+ email: email @ patrickg.com url: http://patrickgibson.com/ ------------------------------------+ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message