- Can you submit tickets to your hosts?
-- If yes; Is this something they do for free or charge for? If free ask them to help it will be easier and quicker if not then consider changing host to one that makes life easier

.
- Do you have WHM access?
-- If yes; Clone (copy) the database via phpmyadmin from WHM (do not copy database while logged into just cPanel you MUST use whm phpmyadmin). Now use the "Database Map Tool" in WHM to assign the correct user account with the database.
Quote:
The Database Map Tool allows you to assign ownership of databases and database users to specific cPanel accounts. This ownership is retained in the internal mapping of databases to users and will allow management of the databases from within the owner’s cPanel interface.
|
*Once you map the database it will then show in the new domains cPanel account

.