How do I map MySQL and PostgreSQL databases and users to cPanel users?

Introduction

MySQL and PostgreSQL does not have any concept of database ownership; for this reason, cPanel stores the database mappings in the /var/cpanel/databases folder.

If you restore databases manually, you may need to map the databases and usernames to  the cPanel accounts.

Procedure

Mapping the MySQL databases can be done in WHM via "Home »SQL Services » Database Map Tool"

Related documentation: 

Database Map Tool