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
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
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 :) !!