How to Use phpMyAdmin

Managing Your Database with phpMyAdmin

phpMyAdmin is a web-based interface for managing MySQL databases. You can use it to browse tables, run SQL queries, import/export data and more.

How to Access phpMyAdmin

1. Log in to cPanel
2. In the Databases section, click phpMyAdmin
3. Click on your database name in the left sidebar

Common Tasks

Export (Backup) a Database

1. Select your database in the left panel
2. Click the Export tab
3. Leave settings on Quick and format as SQL
4. Click Go - the .sql file will download to your computer

Import a Database

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

Reset WordPress Admin Password via phpMyAdmin

1. Open phpMyAdmin and select your WordPress database
2. Open the wp_users table
3. Click Edit next to the admin user
4. Set user_pass to your new password and select MD5 from the function dropdown
5. Click Go

Warning

Always back up your database before making changes in phpMyAdmin. Incorrect queries can damage or destroy data.