I have a cron job that uses mysqldump to backup a database. In order to automate this I have to supply the password in the cronjob shell script in clear text. This feels like a security risk, and makes me uncomfortable. I've reduced the read permissions on this file to as low as possible, but it still feels dangerous.
Does anyone know a way for me to back up this database automatically without having to store a password in clear text?