How to Manage a Database with phpMyAdmin
phpMyAdmin is the visual database manager built into cPanel — browse tables, fix a value, run a query or export data without any extra software.
Step-by-step
- Open Databases → phpMyAdmin in cPanel (no extra login needed — it authenticates as your account).
- Select your database in the left sidebar to list its tables with row counts.
- Browse data: click a table → Browse tab. Click the pencil icon on any row to edit values; Save writes immediately.
- Search without SQL: table → Search tab → fill the fields → Go.
- Run SQL when needed: SQL tab → type the query → Go. Test SELECTs before running UPDATE/DELETE, and always with a WHERE clause.
- Export a quick backup before risky edits: database → Export tab → Quick → Go downloads a full .sql dump (details in the import/export guide).
- Log out by closing the tab when done — sessions expire automatically.
💡 Good to know
- There is no undo in phpMyAdmin — the pre-edit export habit will save you one day.
- Changing site content is usually better done in the application's own admin; phpMyAdmin is for surgical fixes.
- Large tables: use the page navigation rather than "Show all", which can time out.