phpMyAdmin is a web-based tool included with cPanel that lets you browse, modify, and back up your MySQL databases without needing command-line access. Here's how to get started.
Steps
1. Open phpMyAdmin
- Log in to your cPanel account
- From the Home page, go to Databases → phpMyAdmin
- Or from MySQL Databases, find the database in the list and click the phpMyAdmin link next to it
2. Browse your database
- The left sidebar shows all your databases
- Click a database name to expand it and see its tables
- Click a table name to view its data
3. View table structure
- Select a table (left sidebar)
- Click the Structure tab to see column names, data types, and indexes
- Use this to understand your data layout or modify column definitions
4. Edit data
- Click a table name to view records
- Click the Edit icon (pencil) next to any row to modify its values
- Click Save (or Go) when finished
5. Add new records
- Open a table and click Insert at the top
- Fill in the form fields
- Click Go to add the record
6. Run SQL queries
- Click the SQL tab at the top
- Paste or type your SQL command (SELECT, UPDATE, DELETE, etc.)
- Click Go to execute
7. Back up your database
- Select the database (left sidebar)
- Click Export at the top
- Leave defaults selected (or adjust format/compression as needed)
- Click Go to download the backup file
Tips & Notes
- Accidental changes: If you accidentally modify or delete data, restore from a backup file using the Import tab (select your .sql backup and click Go).
- Large tables: If a table has thousands of rows, phpMyAdmin may load slowly. Use SQL queries to filter data (e.g.,
SELECT * FROM table WHERE id > 1000 LIMIT 100). - Performance: Avoid running large operations (bulk deletes, complex joins) during peak traffic times; they can slow your site.
- Safety: Always keep a recent backup before making structural changes (adding/removing columns, indexes, etc.).
- Reset password: If you forget a database user's password, return to cPanel's MySQL Databases tool to change it (no phpMyAdmin access required).