Mysql database size shows 0mb in cpanel: how to solve

Updae Mysql databases through the following command through root

# /usr/local/cpanel/bin/setupdbmap
OR
1) Edit /var/cpanel/cpanel.config

Change:

disk_usage_include_sqldbs=0

to

disk_usage_include_sqldbs=1

Then run the following:

/scripts/update_db_cache

This may take a few minutes if you have a ton of users with databases, but after this, you should see the database disk usage show up accurately in cPanel.

Done...