Re: sql-mode password display

[rb]

Kevin Rodgers <ihs_4664@yahoo.com> writes:

> rb wrote:
>  > When I use sql mode:
>  >
>  > M-x sql-mysql, 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
> 
> What happens if you don't enter your password when prompted by M-x
> sql-mysql, i.e. just type RET?

Thank you for the suggestion,

Without password, the server rejects the connection attempt - it is
configured to require passwords.

[...]

> M-: (string-match comint-password-prompt-regexp "Enter password: ") RET
> returns nil, so I would try
> 
> (setq comint-password-prompt-regexp
>        "\\(\\([Oo]ld \\|[Nn]ew \\|'s \\|login \\|Kerberos \\|CVS
> \\|UNIX \\| SMB \\|^\\)[Pp]assword\\( (again)\\)?\\|pass
> phrase\\|\\(Enter\\|Repeat\\) pass ?\\(word\\|phrase\\)\\)\\( for
> [^:]+\\)?:\\s *\\'")

that is what the value of comint-password-prompt-regexp already is, as
mentioned:

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

sorry, if that wasn't said clearly.

rb
--