Symptoms
When running the script "/scripts/pkgacct" or daily backups, it can be observed that some MySQL users stop working.
ERROR 1045 (28000): Access denied for user 'database_user'@'localhost' (using password: YES)
Description
During "/scripts/pkgacct" or daily backups, cPanel will attempt to ensure the account is in the same state of suspended or unsuspended when the backup completes. If the account is only partially suspended, it can cause the pkgacct script to re-lock the MySQL users after the backup completes. This state shouldn't normally occur, but when actions are terminated or not completed correctly in cPanel, some data may be left in an inconsistent state.
Workaround
Ensure the account is fully suspended:
/scripts/suspendacct cpanel-username
Then unsuspend the account once more:
/scripts/unsuspendacct cpanel-username
Note: Replace cpanel-username with the username of your cPanel account that experiences the issue.