Databases Missing from phpMyAdmin Navigation

Operating System & Version
Linux
cPanel & WHM Version
Don't Know

PostAlmostAnything

Well-Known Member
Mar 3, 2020
100
2
18
Portland, Oregon
cPanel Access Level
Website Owner
I have some databases that were created by Wordpress Toolkit in cPanel which I cannot find in phpMyAdmin no matter what I do. I've tried logging into WHM as the root user and accessing phpMyAdmin that way which shows most databases, but not all of them. In the past I have had problems with databases under this account not being visible when logged into cPanel using that account but they've always been accessible as the root user before.

How do I make phpMyAdmin show every database when logged in as root?
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
15,163
2,409
363
cPanel Access Level
Root Administrator
Hey there!

How do I make phpMyAdmin show every database when logged in as root?
It does - there isn't a way for those to hide from the root user. The next thing to check would be the list of databases directly on the command line in the /var/lib/mysql directory to see if that database is present on the server. You could also use the "show databases;" command from the mysql command line prompt or the following search option straight from the Bash command line:

Code:
mysql -e "show databases;" | grep database_name