How to Use phpMyAdmin in cPanel

phpMyAdmin is a web-based tool for managing MySQL databases. You can run SQL queries, edit tables, and import/export data all from your browser.

Accessing phpMyAdmin

Log in to cPanel → Databases → phpMyAdmin. Click on a database in the left sidebar to open it.

Browsing Tables

Click a table name to view its contents. Use the pagination controls to navigate large tables.

Running SQL Queries

Click the SQL tab, type your query, and click Go.

Example: SELECT * FROM wp_posts WHERE post_status = 'publish';

Exporting a Database

1. Select your database in the left sidebar
2. Click Export tab
3. Choose Quick export method and SQL format
4. Click Go — a .sql file downloads to your computer

Importing a Database

1. Select your database in the left sidebar
2. Click Import tab
3. Click Choose File, select your .sql file
4. Click Go

Tips

• Always export a backup before making changes to production databases
• Use phpMyAdmin to change the WordPress admin password if locked out
• Large imports (over 50MB) may need to be done via SSH command line instead