Knowledgebase

Where Your Database Lives Print

  • databasesphpmyadmin, databases, database, cpanel, guide, howto, solution, zillionkinghost
  • 0

Finding it in cPanel.

LISTING YOUR DATABASES

cPanel > MySQL Databases. It shows every database on the account, its size, and which users have access.

FINDING WHICH ONE A SITE USES

Read the site's configuration file. The database name is there.

With several sites on one account, this is the only reliable way to tell which database belongs to which site.

Record it somewhere. During an incident you do not want to be working it out.

THE SIZE COLUMN

Useful for spotting a database that has grown unexpectedly, which usually means bloat rather than content.

DATABASE USERS

Listed separately. A user is not a database; it is an account permitted to access one.

A database with no user assigned cannot be reached by anything.

WHAT COUNTS AGAINST YOUR PLAN

Most plans limit the number of databases. Check the statistics panel.

An account at its limit cannot create another, and installers fail without explaining that clearly.

OLD DATABASES

Accounts accumulate databases from applications long since removed. Review occasionally.


Was this answer helpful?
Back

Are you happy with your experience? Leave us a review on Trustpilot.


Trustpilot