On Mon, Sep 12, 2011 at 03:30, Craig White craigwhite@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.