01 / Platform and software / C.06How it works
C.06

Database management

Every database on every server sits in one list, with its size, table count, wasted space, slow queries and last backup. Filters pull out the databases with no backup and the ones that have grown too big. You set user privileges and remote access from the same screen.

Screen sheetC.06
Topic
C · Platform and software
Order
06 / 06
Points
06
Panel support
3 / 4 panels
02 / FigurePanel screen
Hover the numbers
app.ctapanel.com/databasesDatabasesweb01.ams · 218 databasesNew databaseDatabases218Total size41.8 GBReclaimable1.9 GBNo backup6never backed upDatabaseSizeReclaimableSlow queriesBackupatolyey_shop2.4 GB180 MB41backed upatolyey_wp412 MB—8backed upsirin_crm8.1 GB1.2 GB112nonemavi_logs96 MB—3backed upDrop sirin_crm?8.1 GB and 112 tables will be removed. Type the database name to confirm — deleting the wrong row should be hard.Database namesirin_crmDropCancel0102030405
  1. 01The panel’s naming ruleA user prefix is required on cPanel and DirectAdmin, free-form on Plesk; a name can’t be reused on a server.
  2. 02Filters that matterBloated ones, ones with no backup at all and ones with a remote user come to the front.
  3. 03All on the rowSize, reclaimable space, slow queries and last backup; the biggest database sits in the summary row.
  4. 04Reclaim the spaceThe OPTIMIZE equivalent takes the space back and reports how much it recovered.
  5. 05Type the name to dropDropping asks for the database name, so deleting the wrong row is hard.
Fig. 02 — Database management
03 / What it does6 points

What it does.

When you see wasted space, you start the clean-up from the same row and read how much came back, instead of waiting for a disk alert. User privileges and remote access are set here too. A new database follows each panel’s naming rule, so the name you pick is one the panel accepts. Dropping a database asks you to type its name, because deleting the wrong row should not be easy.

  1. The list shows size, table and row counts, reclaimable space, slow queries and last backup. The biggest database sits in the summary row.

  2. Filters surface what matters: bloated databases, ones with no backup at all, ones with a remote user.

  3. New databases follow the panel’s naming rule: a user prefix is required on cPanel and DirectAdmin, free-form on Plesk. A name can’t be reused on the same server.

  4. The OPTIMIZE equivalent reclaims space and reports how much it recovered.

  5. User privileges come in three sets (all, write, read). The remote access switch flips the host between localhost and %.

  6. Dropping one means typing the database name, so deleting the wrong row is hard.

04 / Panel-by-panel support3 / 4 panels

Which panels support it?

Capability Database management

  • yesManaged from the panel
  • yesManaged from the panel
  • yesManaged from the panel
  • noNot possible on that panel

Servers without a control panel have no account, reseller or mailbox management, because those come from the panel itself. Firewall, DNS, services and the terminal work over SSH. See the full table

05 / Platform and software6 screens

Platform and software

Every layer a site runs on top of.

06 / Get started14 days free · No card needed

Connect your first server today.

Free for 14 days, no card needed. Create your account, add your first server with an API token or an SSH key, and the panel starts filling in a few minutes later.

No setup fee · Cancel anytime · EU-hosted