Getting Started with phpMyAdmin

phpMyAdmin is the tool that lets you peer inside your databases and manage them through your browser — no command line required. It’s invaluable for troubleshooting, backups and the occasional direct edit. Here’s a careful introduction for newcomers.

Opening phpMyAdmin

In cPanel, under the Databases section, click phpMyAdmin. It opens in a new tab, already logged in with your account’s databases listed down the left-hand side.

The layout

On the left is a list of your databases; click one to expand its tables. A database is a container, and tables are the spreadsheets inside it that hold your actual data — for WordPress, tables like wp_posts (your content) and wp_options (your settings). Clicking a table shows its rows in the main panel.

Exporting a database (backup)

One of the most useful things phpMyAdmin does is create a database backup.

1. Select your database on the left.
2. Click the Export tab at the top.
3. Leave the method on Quick and the format on SQL.
4. Click Export to download a .sql file.

That file is a complete snapshot you can re-import later. Always take one before making any manual changes.

Importing a database

To restore or migrate, use the Import tab: select your .sql file and click Go. For a clean restore, empty the existing tables first, or import into a fresh database.

Editing data safely

You can edit individual values by browsing a table and clicking Edit on a row. This is handy for fixes like resetting a WordPress password or correcting a setting. The golden rule: export a backup before you change anything. A single wrong edit can break your site, but with a backup you can restore in minutes.

Running searches

The Search tab lets you find specific data within a table without writing any code — useful for locating a particular record. The SQL tab lets you run queries directly, which is powerful but best left until you’re comfortable, as a bad query can affect a lot of rows at once.

A word of caution

phpMyAdmin gives you direct access to the data that runs your site, which means it can break things as easily as fix them. Move slowly, back up first, and if a task involves running SQL you’re not sure about, ask us before you run it. We’re glad to help with database tasks so you don’t have to risk it.