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

webnoob

Member
Jun 3, 2011
10
0
51
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

Member
PartnerNOC
Jan 15, 2008
5
0
51
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

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator