From: Cabbar Duzayak
Date: July 19 2005 11:40pm
Subject: MySQLDump - Command line password
List-Archive: http://lists.mysql.com/mysql/186701
Message-Id: <fdf9ad0005071916406e5fdcfc@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

I have setup cronjobs to take daily backups of my db using mysqldump.
But the problem is, mysqldump requires the password to be passed via
command line, which means anyone on the same machine can take a peek
at my password using "top", "ps -ef", etc.

Is there a way of avoiding this, i.e. making it read the password from
some file, etc? Or, is there any other alternative I can use?

Thanks...