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

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.

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.