[CentOS] No MySQL password in ps aux!

[Dotan Cohen]

On Mon, Sep 12, 2011 at 03:30, Craig White <craigwhite at azapple.com> wrote:
> not exactly sure what point you are trying to make about being
> compromised - not all that relevant but you can still just use -p option
> without the password and get prompted for the password which actually
> solves your question.
>

The password is 32 random characters covering all of ASCII. I don't
want to go look for it several times a day.


> Also, since MySQL is client/server you could probably use the mysql
> client on your local machine and connect to the server and use
> encryption but that isn't what you asked.
>

On the server MySQL only listens to localhost.


> Also, presuming you are using bash on the originating machine, you would
> have it in bash_history, just on a different machine. The point I was
> trying to make is that it is generally a poor idea to put a password
> into a shell command whether mysql or whatever.
>

No, this is why I mentioned the alias. Only the alias shows in my
local history, not the password.

-- 
Dotan Cohen

http://gibberish.co.il
http://what-is-what.com