If
a database exists but is not displayed in cPanel it likely is not
being tracked by the db mapping system.
Check
to see if database is listed in user.yaml by running the
following command:
#cat /var/cpanel/databases/user.yaml
If the result is as follows :
No
databases tracked:
root@server
[~]# cat /var/cpanel/databases/tacct.yaml
---
MYSQL:
dbs:
{}
dbusers:
{}
Follow
the below steps :
To
map missing databases and users run the following:
#/usr/local/cpanel/bin/dbmaptool
cpanelusername --type mysql --databasename
#/usr/local/cpanel/bin/dbmaptool
cpanelusername --type mysql –databaseuser
#/usr/local/cpanel/bin/dbmaptool
cpanelusername --type mysql –databasename
cpanelusername_databaseuser
After the above steps are executed check with the following command if the database has been mapped in the db mapping system.
#cat
/var/cpanel/databases/abc.yaml
The result should be as follows :
---
MYSQL:
dbs:
tacct_testdb:
IP Address
dbusers:
{}
owner:
tacct
server: IP Address