Whenever I run drush sql-dump it will prompt me for the database password. Is there a way that this can be done automatically? I don't quite understand why its not just reading this from settings.php
When I do a drush status --show-passwords it is shown there.
I ask because I want to script db backups to happen via drush. Any advice? Thanks!