Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

When creating a database through an SQL statement in phpMyAdmin, it gets created alright, but it is not appearing in my list of Databases in my cPanel.

When I create the database through cPanel however, it all works. What if I want to restore a database and I want it to appear in the cPanel list?

What am I doing wrong? Thanks! :)

share|improve this question

3 Answers 3

I had exactly the same problem and I was able to overcome this by logging into WHM and using the tool called "Database Map Tool". It allows you to select the user account then tell it what database name you want to give the user access to.

share|improve this answer

PhpMyadmin only shows the databases the logged in user has perms for. If you created a Db in cPanel as the site owner but are using a different user in phpMyadmin, That would explain it.

share|improve this answer
I am using my cpanel account for phpMyAdmin - but it wont let me log out - when I press Log Out, its like it refreshes the page. the thing is, I am creating the DB in phpMyadmin, and it appears in there at all times, however its not appearing in cPanel. And because DROP statements are disabled, I can delete the database.. –  Jeff Jul 6 '11 at 13:42

If a database isn't showing up in cPanel but it is in PHPMyAdmin you should run the following command:


This should correct it and make the database visible in cPanel.

share|improve this answer
Is that command runable from the System(); routine in PHP? –  Jeff Jul 7 '11 at 19:27
I need to be able to do it through PHP :) –  Jeff Jul 7 '11 at 19:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.