Database Access

Opening phpMyAdmin From Your cPanel Dashboard

Get into phpMyAdmin through cPanel to browse tables, run SQL queries, and export or import a database safely.

1-Click

Access to phpMyAdmin from the cPanel dashboard

Auto-Login

No separate password needed for account databases

Daily

Backups in addition to manual phpMyAdmin exports

24/7

Human support if a database won't load or import

In short

To access phpMyAdmin, log into cPanel and click the phpMyAdmin icon in the Databases section — it opens already authenticated, with no separate login required for databases owned by that account. From there, select the database in the left sidebar to browse its tables, run SQL under the SQL tab, or use Export and Import for backups and migrations.

Because phpMyAdmin edits live data directly, exporting a backup copy before running any manual query or structural change is the safest habit to build.

phpMyAdmin is the tool that sits between a website's application code and its actual MySQL or MariaDB database, and it's where a site owner goes when a plugin's settings page can't do what's needed — recovering a forgotten admin password by editing a table directly, checking whether a form's submissions actually saved, or pulling a full database export before a big update.

cPanel bundles phpMyAdmin for every database on the account and handles the login automatically, so there's no separate username or password to manage day to day. Knowing where the icon lives and how to move around its interface without accidentally breaking live data is the difference between a two-minute fix and a support ticket.

Where phpMyAdmin Lives in cPanel

Inside cPanel, the Databases section holds MySQL Databases, MySQL Database Wizard, and phpMyAdmin as separate icons, usually grouped together near the middle of the dashboard. Clicking phpMyAdmin opens it in the same browser tab, already logged in under the cPanel account's database privileges — there's no extra username or password prompt to get past.

Every database created under that cPanel account, along with its table structure and stored data, is visible in the left-hand panel the moment phpMyAdmin loads. Accounts with several databases — one per WordPress install, for example — will see all of them listed and can switch between them just by clicking a different name.

Browsing Tables and Running a Query

Clicking a database name expands its list of tables, and clicking any single table opens its rows in a spreadsheet-style Browse view. This is the fastest way to confirm whether a plugin actually wrote data, whether a specific row exists, or what value a setting currently holds without going through the application's own interface.

The SQL tab above the table list accepts a raw SQL statement and runs it directly against the database. This is powerful — a single UPDATE or DELETE statement typed correctly (or incorrectly) affects real rows immediately, so testing a SELECT version of the same WHERE clause first, to see exactly which rows would be affected, is a habit worth keeping.

Exporting a Database for Backup or Migration

The Export tab, available once a database is selected, generates a .sql file containing every table's structure and data in one download — the standard format for a manual backup or for moving a site to different hosting. Quick export uses sensible defaults; Custom export exposes options like compressing the file or exporting only specific tables.

For a WordPress site being migrated manually, this exported .sql file paired with the wp-content folder from File Manager covers everything the site needs to run elsewhere. Keeping a dated copy of this export before any major plugin update gives a fast way back if the update goes wrong.

Importing a Database Back In

The Import tab accepts a .sql file (or a compressed .zip or .gz version of one) and rebuilds the database's tables and data from it. This is the reverse of Export, used when restoring from a backup or bringing in a database exported from another hosting environment entirely.

Large export files sometimes exceed phpMyAdmin's default upload size limit through the browser; in that case, uploading the compressed file directly via File Manager first and importing from there, or asking support to import server-side, avoids the browser timing out partway through a large restore.

Database Access That Doesn't Slow You Down

phpMyAdmin ships with every cPanel-style account on Hosting Cheap, already authenticated and reachable in one click, so checking a table or running a quick query never means hunting for a separate login.

The NVMe SSD storage underneath means a browse of a large table or a bulk import loads quickly, and daily backups run in the background as a second safety net on top of any manual export.

phpMyAdmin included and pre-authenticated in every account
Pure NVMe SSD for fast table browsing and imports
Daily backups in addition to manual database exports
24/7 human support for large or failed database imports

Why Hosting Cheap

What you get

One-Click phpMyAdmin Access

Open phpMyAdmin from cPanel already logged in, with no separate database password to track.

Pure NVMe SSD + LiteSpeed

Browse large tables and run queries fast, even on databases with heavy WordPress or WooCommerce data.

Daily Backups

An automatic safety net that sits alongside any manual export made through phpMyAdmin.

Free Managed Migration

Get help moving a database to Hosting Cheap without wrestling with export and import limits alone.

24/7 Human Support

Real help when a large import stalls or an export file won't download.

30-Day Money-Back Guarantee

Try database and hosting tools risk-free within the first month.

How It Works

Get set up in a few steps

Open phpMyAdmin from cPanel

Log into cPanel and click the phpMyAdmin icon in the Databases section.

Select the database

Choose the right database from the left sidebar to see its tables and data.

Export, import, or query

Use the Export tab for a backup, Import for a restore, or the SQL tab to run a direct query.

Included

Everything you need, on every plan

Confirm which database belongs to which website before making changes
Run a SELECT query first to preview rows before any UPDATE or DELETE
Export a full backup before running a manual SQL statement
Use Custom export to compress large databases before downloading
Upload oversized .sql files via File Manager if the browser import times out
Keep a dated copy of each export in case a rollback is needed
Double-check the WHERE clause on any query that changes multiple rows
Verify table row counts after an import match the source database

FAQ

Frequently asked questions

Do I need a separate password to log into phpMyAdmin?

No. Opening phpMyAdmin from the cPanel dashboard authenticates automatically using the cPanel account's own database privileges, so there's no extra login screen for databases created under that account.

Can phpMyAdmin permanently delete data if I run the wrong query?

Yes — an UPDATE or DELETE statement without a precise WHERE clause changes or removes rows immediately and permanently. Running the equivalent SELECT statement first to preview exactly which rows match is the safest way to avoid an accidental mass change.

What file format does phpMyAdmin use for exports?

The standard export is a .sql file containing the SQL statements needed to recreate every table's structure and data. Custom export also allows compressing that file as a .zip or .gz to keep the download smaller.

Why does my database import fail partway through?

The most common cause is the file exceeding phpMyAdmin's upload size limit for browser-based imports. Compressing the file first, uploading it via File Manager, or asking support to run the import server-side usually resolves it.

Can I use phpMyAdmin to find a specific WordPress setting stored in the database?

Yes — browsing the wp_options table and searching for the option name in the Browse view, or running a targeted SELECT query in the SQL tab, shows exactly what value is currently stored without needing the WordPress admin area.

Is phpMyAdmin the same as a MySQL database itself?

No — phpMyAdmin is just the browser-based interface for viewing and managing a MySQL or MariaDB database. The database and its data exist independently; phpMyAdmin simply provides a visual way to reach it instead of typing raw commands in a terminal.

Get cPanel Hosting With phpMyAdmin Built In

Manage every database from one dashboard, backed by NVMe SSD and 24/7 human support.

Get Started