PHPMyAdmin doesn’t show all databases in cPanel

PHPMyAdmin doesn’t show all databases in cPanel

New databases that are created in cPanel are not visible in PHPMyAdmin, but if you assign a user to it and access it as that user, then you can use it.

The first thing to check is if the database is visible via CMD:

mysql -uCPANEL_USERNAME -p
image 38 - PHPMyAdmin doesn't show all databases in cPanel

If the database IS NOT visible from both the terminal and PHPMyAdmin then:

  1. Restart the cPanel user password from WHM

If the database IS visible from the terminal but not from the PHPMyAdmin then:

Home > Server Configuration > Tweak Settings, click on the Software tab and enable phpMyAdmin information schema searches.

image 39 1024x486 - PHPMyAdmin doesn't show all databases in cPanel
whoami
Stefan Pejcic
Join the discussion

I enjoy constructive responses and professional comments to my posts, and invite anyone to comment or link to my site.