Managing databases with phpMyAdmin

Using phpMyAdmin

phpMyAdmin is a visual tool for managing MySQL databases.

Accessing phpMyAdmin

1. Log in to cPanel
2. Click phpMyAdmin
3. Select your database from the left sidebar

Browsing Data

1. Click a database name
2. Click a table name
3. Use Browse tab to view records

Running SQL Queries

1. Select your database
2. Click the SQL tab
3. Enter your query
4. Click Go

Common Tasks

• Search: Use the Search tab to find data
• Edit: Click Edit next to any row
• Delete: Select rows and click Delete
• Empty table: Operations → Empty the table

Table Operations

• Rename: Operations → Rename table
• Copy: Operations → Copy table
• Repair: Operations → Repair table
• Optimise: Operations → Optimise table