Imported Database Missing in cPanel

When a database is uploaded to a server via WHM (Web Host Manager), it may not be visible to any cPanel account, making it appear as if it doesn't exist. To address this, you can utilize the Database Map Tool in Root WHM, the web-based control panel for server administrators. This tool allows you to assign the database to a specific cPanel user, ensuring its visibility and accessibility within their account. By associating the uploaded database with the appropriate cPanel account, you enable the user to manage and interact with the database using their cPanel tools, effectively resolving the issue and facilitating proper allocation of databases across multiple cPanel accounts.

This article will explain the process of finding the database name/s and assigning them to the correct cPanel user.

Related Articles

Import MySQL Database From Command Line
Import MySQL Database Using phpMyAdmin
Add User to MySQL Database

Assign the Database

IMPORTANT: This solution will require root access. If this needs to be obtained, follow the guide on requesting root access.

1. Access your server via SSH as the root user or using the Terminal in Root WHM
2. Enter the MySQL CLI by using the following command

   mysql 

3. List the databases with the following command

   show databases;

   EXAMPLE: The output will list the databases found.  In this example, we would want to userna5 user to own userna5_db0 and userna5_db1.
   

   MariaDB [(none)]> show databases;
   +--------------------+
   | Database           |
   +--------------------+
   | userna5_db0       |
   | userna5_db1       |
   | information_schema |
   | mysql              |
   | performance_schema |
   +--------------------+​

4. Log into Root WHM
   
5. Navigate to the Database Map Tool, located in the SQL Services section
   
6. Select the correct cPanel account
7. Enter a comma-separated list of databases or database users to assign to the cPanel
   CAUTION: This tool should only be used to assign databases that have not already been assigned to a cPanel account.
8. Click Submit