PHPMyAdmin Overview

What is PHPMyAdmin?

 

The administration of a MySQL database throughout the internet is managed by a tool written in PHP called PHPMyAdmin.  The database itself is first setup in cPanel but PHPMyAdmin manages its functions.  For example, PHPMyAdmin can create and alter databases. You can use it to add, edit, delete fields, drop entire databases, run SQL statements or even transmit information into different formats and administer keys. Basically, any table command you would run from shell at the mysql prompt can be accomplished here in this graphical user interface. 

 

How Do I Access PHPMyAdmin?

 

To find PHPMyAdmin on your cPanel, log in and go to Home > Databases > PHPMyAdmin.

 

Showing where the phpMyAdmin icon is located in cPanel

 

What Does PHPMyAdmin do?

 

After you create a database you’ll be able to use the functionality of PHPMyAdmin.  Here are the basic functions of the application,

 

  • Browse Databases
  • View MySQL Processes
  • Searches and SQL Queries
  • Database Functions
  • Manipulating Tables
  • Manipulating Columns

 

Showing phpMyAdmin in cPanel

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Adding a MySQL user to a database

How do I Add a User to a MySQL Database? You can easily add a user to specific MySQL...

Application Cannot Connect to Database

What causes an application cannot connect to database error? There are several things that...

Creating a MySQL Database

How do I Setup a MySQL Database in cPanel? Setting up a database for your website can be done...

Creating a MySQL User

How Do I Create A MySQL User In cPanel? To create a MySQL user follow the guide below.  This...

Definition of Databases Icons

The Database section in cPanel allows you to administer every aspect of your MySQL database....