Skip to main content
phpMyAdmin is the web-based MySQL client included with every cPanel hosting account. It’s how you’d browse data, run queries, take backups, and fix table corruption without ever opening a terminal. Open it from cPanel home → Databases → phpMyAdmin. cPanel logs you in automatically as your account user, no extra password.
phpMyAdmin landing page

​
What’s covered

Browse data

Navigate the database tree, open a table, page through rows, and edit cells inline.

Import a dump

Restore a .sql or .sql.gz file. Includes the workaround for files larger than the upload limit.

Export for backup

Quick vs custom mode, format options, compression.

Run SQL queries

The SQL tab, query history, and bookmarks.

Table operations

Repair, optimize, rename, change collation, truncate, drop.

​
What you can’t do

phpMyAdmin on shared hosting hides the things that need server-wide privileges:
  • No access to the mysql system database (no editing global users or grants)
  • No Variables or Status server-config pages
  • No Privileges tab at the top level (use Manage My Databases for that)
You’re sandboxed to your own databases. That’s a feature, not a limitation.

​
Tips that save time

  • The left tree filters as you type. Click into the search box above it and start typing a table name to jump straight to it.
  • Every action you take through the UI prints the equivalent SQL above the result. Copy it into a script when you want to repeat the operation.
  • The Bookmarks feature on the SQL tab keeps recent queries around. Useful for repeated cleanup tasks.

​
Need a hand?