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:

Home »SQL Services » Database Map Tool

Related documentation:

Database Map Tool