Managing Database Data with phpMyAdmin

phpMyAdmin is a de facto standard for administrating databases in an easy point-n-click manner and makes editing and updating tables manually very easy.

Accessing phpMyAdmin

  • Login to cPanel
  • Click on phpMyAdmin

Once open you will be presented with your databases on the left which you just click to open and on the right will be where all of your tables show with their prefixes such as forum_, wp_ and more if you have more than one script using the same database.


The tabs at the top allow you to do many functions and operations on your database...

  • Structure displays all of the current tables in an overview
  • SQL allows you to run SQL queries and statements directly
  • Search allows you to build and perform searches within your database tables
  • Query allows you to build complex queries to run on your database
  • Export allows you to create backups of your database
  • Import allows you to import backups or other SQL files
  • Operations allows you to easily create new tables and more

If you were to check a table and select the drop-down menu at the bottom of the list you can perform a number of tasks...

  • Empty allows you to remove ALL records within the selected table(s)
  • Drop allows you to completely remove the selected table(s)
  • Print View generates a reference guide
  • Check performs error checking on your tables
  • Optimize performs a performance check and ensures data and structure are in optimum configuration
  • Repair checks for errors and repairs them if found
  • Analyze collects information about the table, validates its structure and identifies issues

Table View

Opening a table you will be able to see individual field structures within that table, by selecting a check box you can perform operations with that row including editing and more via the icons below.

For more information...

This is a very brief article covering the basics of phpMyAdmin, you should refer to documentation available within phpMyAdmin for more in-depth information.


Content and instructions found on third-party sites and services may not be complete, accurate or applicable in whole or part, reliance upon third-party content is solely at your own discretion and risk.

Was this answer helpful?

Related Articles

Using FTP to Manage Files

To use FTP to manage files you will need three key pieces of information... Your Username (eg....

Managing MySQL User Accounts

For security, you have the ability to create individual MySQL users to use with one or more...

How to transfer your accounts from your old host

- login to cPanel- click backups- click 'Home Directory' under Partial Backups- choose a location...

How to manage files via cPanel File Manager

You can also use the built-in File Manager capabilities of your cPanel which is easy and doesn't...

How to enable Remote MySQL Usage/Management

If you need to connect to your databases remotely through MySQL management software such as MySQL...