How to Access phpMyAdmin from cPanel?

Description

phpMyAdmin is a web-based tool for managing your MySQL databases. You can use it to view tables, run queries, import or export data, and edit records without needing command-line access.

How to access phpMyAdmin

  1. Log in to your cPanel account.
  2. Scroll down to the Databases section.
  3. Click the phpMyAdmin icon (search “phpMyAdmin” in the cPanel search bar if you don’t see it).
  4. phpMyAdmin opens in a new browser tab, already logged in. No separate username or password is needed.
  5. In the left-hand panel, click the name of the database you want to manage to see its tables

Common tasks

  • Browse or edit data: click a table name, then the Browse tab.
  • Run SQL queries: select your database, then click the SQL tab.
  • Export a database (backup): select your database, then click the Export tab.
  • Import a database: select your database, then click the Import tab.

Troubleshooting

  • Pop-up blocked: if nothing happens when you click the icon, allow pop-ups for your cPanel page and try again.
  • Session timed out: phpMyAdmin logs you out after a period of inactivity. Close the tab and click the icon in cPanel again.
  • Import fails or times out on large databases: phpMyAdmin has an upload size limit. For larger files, see How to Upload a Large Database Using cPanel Terminal.
  • Export fails or times out on large databases: see How to Export a Large Database Using cPanel Terminal.
  • Database not listed: make sure the database exists and your cPanel user is assigned to it under Databases → MySQL Databases.

Caution: Changes made in phpMyAdmin (such as deleting tables or running DROP/DELETE queries) take effect immediately and cannot be undone. Take a backup of your database before making major changes.

Was this answer helpful? 33 Users Found This Useful (68 Votes)