1. Home
  2. MySQL
  3. Database appears in MySQL Manager, but not phpMyAdmin

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.

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



Updated on July 8, 2019

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help! If you get an error, visit https://lithiumhosting.com/support instead.
Contact Support