Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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
add comment

3 Answers

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
add comment

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

/usr/local/cpanel/bin/setupdbmap

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
add comment

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
add comment

Your Answer

 
discard

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.