On Sun, 2011-09-11 at 19:32 +0300, Dotan Cohen wrote: > I just noticed that some CentOS 4 or 5 machine that I don't admin but > have root access to hides MySQL passwords from ps: > > Console 1: > $ mysql -u root -pSECRET > mysql > > > Console2: > # ps aux > root 32165 0.0 0.1 109408 2204 pts/1 Ss+ 11:19 0:00 mysql > -u root -px xxxxxxxxxxxxxxxxxx > > That is really nice, is it a MySQL feature or a CentOS feature? I have > some other servers that I _do_ admin and I'd like to enable this. ---- you'd still have it in bash_history though so it's really a poor idea to ever pass a significant password directly on the command line execution - whether visible or not visible to ps. Much better is to be prompted for the password instead... mysql mysql -u root -p and it will prompt another option is to have ~/.my.cnf which already has your password Craig -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.