Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

closed as off-topic by HopelessN00b Jan 13 '15 at 21:52

  • This question does not appear to be about server, networking, or related infrastructure administration within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.

This question appears to be off-topic because it is about working with a service provider's management interface, such as cPanel. – HopelessN00b Jan 13 '15 at 21:52
It's still server related - are questions about working with Windows or Linux interfaces also prohibited? Is it all about that CLI? I don't think we'll ever be able to avoid questions that involve some third party interface in some way. – Jeff Jan 14 '15 at 7:09

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

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