Resolved Issue with website restore from Plesk backup "Access denied for user 'backup_vwcor4b'@'localhost' (using password: YES)"

[Bitpalast]

I have tried to restore a customer backup from their original Plesk backup. Restore option "Website", choosing a domain of their subscription (not the main domain). Result:

Warning: Restore hosting "<domain name>"
Failed deployment of database <database name> (domain <subscription name>)
Warning:
Errors occurred during deployment of database content. Not all content may be restored. Resolve the errors if required or try to restore the content manually from the archive: databases/<database name>_1[sqldump]: backup_sqldump_2107310302_2108060302.tgz
Warning:
Execution of /usr/bin/mysql --defaults-file=/etc/my.cnf -u backup_vwcor4b -h localhost -P 3306 --default-character-set utf8mb4 <database name> failed with return code 1.
Stdin is
source /tmp/pmm-ru-udb-dump-5iiQT3/backup_sqldump_2107310302_2108060302;
exit
Stderr is
ERROR 1045 (28000): Access denied for user 'backup_vwcor4b'@'localhost' (using password: YES)
Last error is
Resource temporarily unavailable

However, when I import backup_sqldump_2107310302_2108060302 directly, e.g. with the GUI database import function, the database can be imported without any issues. It is also possible to restore the files from the backup. I was able to do the restore manually with the file and a file-restore from the backup.

What I do not understand: What is causing this Plesk backup restore error. I am not aware of a "backup_vwcor4b" user.

 

[IgorG]

Peter, I think this problem is addressed in the following KB: Cannot access database with PHPmyadmin or restore it: Access denied for user 'jdoe'@'localhost' (using password: YES)

 

[Bitpalast]

Thank you.