phpMyAdmin is a web-based tool in cPanel used to view, edit, and manage your MySQL databases.
1. Open phpMyAdmin
Log in to cPanel and click phpMyAdmin.
2. Select Your Database
On the left sidebar, click your database name.
3. View Tables
You will see a list of tables used by your application (e.g., WordPress tables like wp_posts).
4. Run SQL Queries
Click the SQL tab to run custom queries.
This is useful for debugging, updating values, or importing scripts.
5. Import a Database
Click Import, upload your .sql file, and execute.
Large imports may fail due to upload limits—use alternative methods if needed.
6. Export a Database
Click Export to download a backup of your database.
When to Use phpMyAdmin
- Quick edits or fixes
- Import/export backups
- Running SQL queries
Limitations
- Not ideal for large databases
- Browser timeouts on big imports
Done
You now know how to manage your database using phpMyAdmin.
