Managing Your Database Using phpMyAdmin

phpMyAdmin is a software tool, written in PHP, intended to handle the administration of MySQL via web browser. phpMyAdmin supports a wide range of operations with MySQL.

The most frequently used operations (managing databases, tables, fields, relations, indexes, users, permissions, etc.) are supported by the user interface, while you still have the ability to directly execute any SQL statement.

phpMyAdmin can be accessed via your cPanel or Plesk control panel and is integrated with your HostGator hosting account.


Accessing phpMyAdmin

cPanel

Log into cPanel and click the phpMyAdmin icon in the Databases section.

Plesk

See the directions on how to access Webadmin. The Webadmin icon takes you to phpMyAdmin for MySQL databases.


Basic Functions of phpMyAdmin

Creating Databases & Users

Before you can get started using phpMyAdmin, you must create your database from within the HostGator cPanel.

Navigating The Home Screen

At the phpMyAdmin home page, you will see options for:

  • Collation
  • Language
  • Font size
  • Documentation
  • Wiki
  • phpMyAdmin official home page

Selecting Databases

To view the structure of your databases, simply click on the database name in the left column of the home page. Alternatively, you may click on the databases tab along the top of the screen.

Clicking on the name of the database shows the structure of the database. The structure shows individual table names which make up your database.

Browsing Databases

Once you have selected a database, you can browse it by clicking the 1st icon under action (beside the table name) while in the structure view.

  • The Browse view displays rows of data within the database (if applicable).
  • There is also a link to Create PHP Code based on the current view.
  • Navigate through the rows of data by clicking the > or >> buttons; or choose a page number from the drop-down box.   

Viewing MySQL Processes

You may view the current MySQL processes by selecting the Status tab while at the home page of phpMyAdmin.

To kill a process, click the kill link to the left of the process ID number.


Performing Common Functions in phpMyAdmin

Searches & SQL Queries

Database Functions

Manipulating Tables

Manipulating Columns