Login
Get Started
Skip to main content
Help Center
< All Topics
Posted
Updated

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.

Table of Contents
Ryan Botha

Ryan Botha

Ryan is a web hosting specialist and digital marketing consultant based in Johannesburg, South Africa, with over 12 years of experience in the industry. He has helped hundreds of South African businesses get online, improve their Google rankings, and build websites that actually generate leads. Ryan specialises in WordPress, technical SEO, and web performance - and writes to make complex topics easy to understand for business owners.