---
title: phpMyAdmin
description: "A web UI for MySQL/MariaDB: export, import, and emergency SQL. An admin tool — always back up before changing data."
canonical: https://penasihathosting.com/en/hosting-wiki/phpmyadmin
type: wiki
locale: en
updated: 2026-07-15
author: Willya Randika
---

# phpMyAdmin

## Overview

- **Summary:** A web UI for MySQL/MariaDB: export, import, and emergency SQL. An admin tool — always back up before changing data.
- **Author:** Willya Randika ([profile](/penulis/willya-randika))

## Article

**phpMyAdmin** is a web UI for managing [MySQL/MariaDB](/en/hosting-wiki/mysql) databases: browse tables, run SQL, export/import, and emergency fixes. On shared hosting it usually opens from [cPanel](/en/hosting-wiki/cpanel) via the phpMyAdmin icon.

It is an admin tool — not a playground without backups. One wrong `DROP` can take a site down in seconds. Use a checklist, not curiosity alone. Treat every click on a production table as a change that can affect real customers.

## A Simple Analogy

If the database is a filing cabinet, phpMyAdmin is the **clerk’s desk with every drawer key**. One wrong pull can scatter the archive. That is why you photocopy (back up) before a major tidy-up or before moving drawers between rooms.

## Common Tasks

- Export `.sql` before migrations or experiments  
- Import a dump into a new database  
- Inspect `wp_options` (site URLs) after domain moves  
- Remove spam rows or excess revisions (carefully)  
- Repair tables marked crashed (advanced)  
- Add indexes or remove test rows in development environments  

## A Safer Workflow

1. Take a [backup](/en/hosting-wiki/backup-hosting) or at least a database dump  
2. Prefer staging for large changes  
3. Note the queries you run  
4. Verify the site (login, checkout, key pages) afterward  
5. Close the admin browser session when you are done  

## What to Watch For

- **Back up first** before mass DELETE/UPDATE  
- Do not leave phpMyAdmin open on shared computers  
- Lock down access; some hosts add extra protection  
- Large imports may time out — use SSH/`mysql` CLI if needed  
- Dropping the wrong table takes the site down instantly  
- Do not leave SQL dumps inside a public [document root](/en/hosting-wiki/document-root)  

## FAQ

<Accordion>
  <AccordionItem title="Is phpMyAdmin the database itself?">
    No. It is only a UI. The database engine remains MySQL/MariaDB on the server.
  </AccordionItem>
  <AccordionItem title="I do not see a phpMyAdmin menu">
    The host may use Adminer or remote-only access. Check panel docs or ask support.
  </AccordionItem>
  <AccordionItem title="phpMyAdmin vs backup plugins?">
    Scheduled backups are usually easier via host/plugin tools. phpMyAdmin shines for inspection and manual repair.
  </AccordionItem>
  <AccordionItem title="Should I edit wp_users in the UI?">
    Possible, but risky. Resetting passwords via the host panel or WP-CLI is usually safer than hand-editing hashes.
  </AccordionItem>
</Accordion>