I took the backup of the wordpress site. I created a new database (user & database).
When I try to restore the site, the database gets restored to another database user (on the same cpanel) even though I enter the new database details. It has happened twice.