help-gnu-emacs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

sql-mode password display


From: rb
Subject: sql-mode password display
Date: 02 Mar 2005 11:57:30 -0500
User-agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3

When I use sql mode:

M-x sql-msql, then follow prompts, 

I get the interactive sql buffer which works very well for me. The only
problem is that when I list the processes, the mysql process shows my
password, and I would like to know if there is something I can do to
conceal it?

rb@antonio 102% ps -ef | grep sql
      rb      29562      29372  0 08:44:27 pts/4   0:00 grep sql
      rb      29717      15897  0 08:43:34 pts/8   0:00
      /usr/freeware/bin/mysql --user=rb --password=my_password
      --host=sanmarco test

I was trying to find wheter there was a customizable variable to
conceal/display password and with M-x customize-apropos, I discovered
that the password was displayed in the customization buffer as well:

Sql Password: Hide my_password
   State: this option has been changed outside the customize buffer.
Default password. More
Parent groups: Sql

If I start an ineractive mysql session at the command line in an xwsh
shell, I get the following (password not displayed):

rb@antonio 101% ps -ef | grep sql
      rb      29598      29535  0 08:31:14 pts/6   0:00 mysql -h
      sanmarco -u rb -p test

Also, working in shell-mode within emacs, to process a batch file, my
password is displayed in the *shell* buffer, and is retained in the
command history list.

>From Emacs shell buffer:

rb@antonio 98% mysql -vv -h sanmarco -u rb -p < dbs.sql > dbs.out0222
mysql -vv -h sanmarco -u rb -p < dbs.sql > dbs.out0222
Enter password: my_password

Within the shell, any other commands requiring a password (ssh, rlogin,
su, etc), the password is properly not displayed.

This is GNU Emacs 21.3.1. Thank you, sorry if there's an obvious or
known solution...

rb
-- 


reply via email to

[Prev in Thread] Current Thread [Next in Thread]