Command Line created DB not appearing in CPanel but is in phpMyAdmin

[webnoob]

Hi All,

I have done "CREATE DATABASE MYDB" via SSH and it appears in phpMyAdmin, however, when I go to the MySQL Databases section in CPanel, I cannot see it.

I presume there is a file somewhere that needs appending. Can anyone explain what I need to do to make it show as I want other users to be able to delete / see the database is there should they need to.

Many Thanks.
webnoob.

 

[Aleksl]

Hi

Database must be created with prefix - cPanel login. Ex. - CREATE DATABASE login_db
After this - run /usr/local/cpanel/bin/setupdbmap via SSH and database must appear in MySQL Databases section

 

[cPanelKenneth]

When using the command line to create a database for the user, you also need to add it to the database mapping for the user. Please consult the following:

http://docs.cpanel.net/twiki/pub/AllDocumentation/11_28ReleaseNotes/DBMappingWhitePaper_r12.pdf

On the command line you can use /usr/local/cpanel/bin/dbmaptool to update the mapping.