SSH password as a command-line parameter?

[Daniel Carrera]

Hello,

I'm working on a remote backup solution for a small website. I want to 
download a daily copy of a MySQL database. I'd prefer to send it over 
ssh, so I'm thinking of something like this:

ssh me at server.com "mysqldump db_name -u me --password=secret | gzip -c" 
 > sql-backup-2006-06-18.gz


This would work except that I still need to type the ssh password. Is it 
possible to specify the ssh password in the command line? Or do 
something else so I can run this on a script?

Cheers,
Daniel.
-- 
http://opendocumentfellowship.org
   "The reasonable man adapts himself to the world; the
   unreasonable man tries to adapt the world to himself.
   Therefore all progress depends on unreasonable men."
         -- George Bernard Shaw