I am getting the following error for a failed backup every night. I have setup the user correctly, but when I try to login to mysql server using that profile, I am not able to login.
This is the backup error:
==========================================================================
ERROR 1045 (28000): Access denied for user 'abc'@'localhost' (using password: YES)
/home/<xyz>/all_db_backup.sh: line 4: /home/<xyz>: is a directory
========================================================================
My backup program:
==================================================
mysql -u<user> -p<pwd> -e 'show databases' | grep -Ev 'Database|information_schema|performance_schema' | while read dbname; do mysqldump -u<user> -p<pwd> --complete-insert "$dbname" | gzip > ./backups/"$dbname"-`date +%Y-%m-%d-%T`.sql.gz; done
==========================================================
Cronjob:
===========================================================
0 2 * * * sh /home/<user>/all_db_backup.sh
0 3 * * 0 /bin/find /home/<user>/backups -type f -mtime +2 -exec rm -rf {} \;