How to Use phpMyAdmin

Using phpMyAdmin

phpMyAdmin is a web-based tool for managing MySQL databases.

Accessing phpMyAdmin

1. Log into cPanel
2. Go to Databases > phpMyAdmin
3. Select database from left sidebar

Common Tasks

View Tables

1. Click database name in sidebar
2. All tables are listed
3. Click table name to view contents

Browse Table Data

1. Select table
2. Click Browse tab
3. View all rows and columns

Run SQL Query

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

Import Database

1. Select database
2. Click Import tab
3. Click Choose File
4. Select .sql file
5. Click Go
6. Wait for import to complete

Export Database

1. Select database
2. Click Export tab
3. Choose method:
   • Quick: Default settings (recommended)
   • Custom: Advanced options
4. Click Go
5. Database downloads as .sql file

Search Database

1. Select database or table
2. Click Search tab
3. Enter search criteria
4. Click Go

Optimize Database

1. Select database
2. Check boxes next to all tables
3. From "With selected" dropdown, choose Optimize table
4. Click Go

Safety Tips

• Always backup before making changes
• Be careful with DELETE and DROP commands
• Test queries on staging site first
• Don't modify system tables unless you know what you're doing