I am trying to backup my database on my linux box, but I keep getting this error:
mysqldump: Got error: 1045: Access denied for user 'vittoriomysql'@'localhost' (using password: NO) when trying to connect
This is done in a cron job and the command I run is:
mysqldump –opt -Q -u myusername –password=mypassword arp3 > /home/vittorioftp/mysql_backup/EuroDisplay_Arp3_`date +%Y%m%d`.sql
"myusername" is a mysql user that has access to the arp3 database, but it is not a user at linux level.
What could the problem be?