I’m trying to automate a mysqldump with cron. I should be able to specify a default mysql password in “~/.my.cnf”, but nothing seems to be happening when I change the contents of that file. Here’s what I have:
user = website
host = mysql.*******.com
database = website
password = “********”
When I manually execute “mysql” from the shell, I’m still being prompted for a password, and “mysql --help” doesn’t show the changes to the defaults that I set in “~/.my.cnf”, so what am I doing wrong?