Database appears in MySQL Manager, but not phpMyAdmin

Overview

A MySQL database that appears within the control panel under Databases > MySQL Manager does not show in Databases > phpMyAdmin

Cause

Read permissions have been revoked on that database from the primary user.

Solution

Visit Databases > MySQL Manager > Change Mode: List Databases & Users within the control panel.

1. Select the database that does not appear
2. Navigate to the primary user
3. Read will be unchecked. Check Read under privileges.
4. Click Save
   
   

   Sample permission listing where the database will not appear in phpMyAdmin due to insufficient permissions.