mysqldump w/o password

[Asif Iqbal]

Hi All

I have to run this to dump the database

mysqldump -u root -pPASS --opt database > database.tmp

Is there anyway I can hide the PASS is a file ? I was trying to put it in
/root/.my.cnf as this

[client]
password = PASS

That seems to be not working. I am not sure if mysqldump even reads that file.
The only option worked for me is putting the password in a file /root/.pass and
chmod it to 000 and then run this

mysqldump -u root -p`cat /root/.pass` --opt database > database.tmp

However I don't like this option because it tells you where the password is
residing. I need to put this in cron so I don't like the option of showing the
filename

Thanks

--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/loo...rch=0x8B686E08
There's no place like 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw