How to rebuild a cPanel user's database map

Introduction

The cPanel interface will show databases deleted outside of cPanel, or not show databases created outside of cPanel. To correct this, the user's database map needs to be rebuilt. This article provides the steps to rebuild the user's database map with the rebuild_dbmap script.

Procedure

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Run the rebuild_dbmap script with the --noop flag to preview the databases that will be configured in the user's database map.

   /usr/local/cpanel/scripts/rebuild_dbmap --noop $username

   Please note that "$username" must be replaced with the cPanel user's username.
3. Run the script without the --noop flag to rebuild the user's database map.

   /usr/local/cpanel/scripts/rebuild_dbmap $username

   Please note that "$username" must be replaced with the cPanel user's username.
4. Update cPanel's database cache.

   /usr/local/cpanel/scripts/update_db_cache

Additional resources

The rebuild_dbmap Script