phpMyAdmin

phpMyAdmin is a web-based tool for working with MySQL databases. It’s built into cPanel and lets you browse tables, run SQL queries, and manage database users without using the command line.

Open phpMyAdmin

Log in to cPanel through your client area or at yourdomain.com/cpanel. Go to Databases and click phpMyAdmin. cPanel logs you in automatically. You’ll see your databases listed in the left sidebar. Click a database name to view its tables.

What you can do

Task	How
Browse table data	Click a table name, then click the Browse tab
Run SQL queries	Select a database, click the SQL tab, type your query, and click Go
Search across tables	Select a database and click the Search tab to search all tables at once
Manage table structure	Click a table name, then use the Structure tab to add, edit, or remove columns
Import a database	Select a database, click Import, and upload a `.sql` file
Export a database	Select a database, click Export, choose your format, and download
Manage user privileges	Click User accounts to view and edit database user permissions

For step-by-step instructions on importing and exporting, see Import and export MySQL databases.

phpMyAdmin gives you direct access to your database. Deleting tables or running destructive queries cannot be undone unless you have a backup. If you’re unsure about a change, export a backup first.

If you haven’t created a database yet, phpMyAdmin won’t show anything useful. Create one first through the Database Wizard in cPanel.

Import and export MySQL databases

Remote database access

Getting started

Web Hosting

VPS

Network

Account

Open phpMyAdmin

What you can do

​Open phpMyAdmin

​What you can do

Open phpMyAdmin

What you can do