Sunday, March 2, 2014

MySQL databases not showing in cPanel

When I checked Cpanel to check the database details after I created a database via shell, It was shown only a message "No databases found" .

The issue is the database is not mapped to Cpanel.

It was resolved by rebuilding the DB map using the command  

/usr/local/cpanel/bin/setupdbmap

 The Output of the command :

root@abc [~]# /usr/local/cpanel/bin/setupdbmap
info [setupdbmap] Begin setupdbmap
info [setupdbmap] Updating MySQL users
info [setupdbmap] Processing MySQL databases and database users ...
Adding database testabc_database ownership to testabc
Saving MySQL DB mapping for testabc
info [setupdbmap] Finished with MySQL users
info [setupdbmap] Failed to determine PostgreSQL version from server.
info [setupdbmap] End setupdbmap
info [setupdbmap] Storing Database Index
info [setupdbmap] Database Index Complete

Then the database testabc_database has showed in Cpanel > Mysql Datbases.

 Thus the issue resolved :) !!

No comments:

Post a Comment