I have figured out that one particular web site on my server (which is running phpmyrealty) throws an error after cpanel backup is run.
The error is as follows: Initialization Error Access denied for user 'bluefla'@'localhost' (using password: YES).
This error is an indication that the username or password I am using is incorrect.
If I go into cpanel and try and update the password it tells me the old password is not valid, so I go in, delete the user, add the user again and then next time cpanel runs the backup, the site throws an error.
I have also tried adding different usernames and variations of passwords, and still no effect.
I know 100% it happens when cpanel backup runs becasue I just ran /scripts/cpbackup --force in ssh, and two minutes later, site was throwing an error.
On this server there is around 50 sites and no other site has this issue and I have a few servers and have never seen this issue before.
Has anyone seen this issue and can anyone help me to figure it out?
I did post a thread on mysql.com (MySQL :: mysql password keeps getting reset by itself?) but that was before I realised it was cpanel backup causing the issue.
Any help from cpanel on this would be great.