Skip to main content
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

TaskHow
Browse table dataClick a table name, then click the Browse tab
Run SQL queriesSelect a database, click the SQL tab, type your query, and click Go
Search across tablesSelect a database and click the Search tab to search all tables at once
Manage table structureClick a table name, then use the Structure tab to add, edit, or remove columns
Import a databaseSelect a database, click Import, and upload a .sql file
Export a databaseSelect a database, click Export, choose your format, and download
Manage user privilegesClick 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.