1. Knowledge Base
  2. >
  3. phpMyAdmin

phpMyAdmin

 

The phpMyAdmin is a tool written in PHP to handle the administration of MySQL over the web. Databases must be created in cPanel or Plesk, but phpMyAdmin can drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, and export/import data into various formats.

To know more about the functions of phpMyAdmin, please click the links below.


What Are the Basic Functions of phpMyAdmin

Accessing Databases
  • cPanel - You can access your databases via your cPanel's phpMyAdmin. For instructions on how to access phpMyAdmin in cPanel, please refer to this article: How To Access phpMyAdmin from cPanel.
  • Plesk - You may want to see the directions on how to manage your databases via Plesk's Webadmin in this article: How To Access Webadmin.
  • Root WHM on a VPS or Dedicated Hosting - Users of VPS or Dedicated hosting may also access phpMyAdmin by navigating to WHM's SQL Services section.

    WHM - SQL Services - phpMyAdmin section

Creating Databases and Users

Before you can get started using phpMyAdmin, you must first create your database through the following sections:

cPanel's MySQL Databases

phpMyAdmin - Create Database

Plesk's Databases

Plesk - Add Database

Selecting Databases

To view the structure of your databases, simply click on the database name in the left column of the home page.

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

phpMyAdmin - Select Database

Browsing Databases

Once you have selected a database, you can browse each table by clicking the Browse link besides 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. You can also navigate through the rows of data by clicking the > or >> buttons or choose a page number from the dropdown box.

phpMyAdmin - Structure - Browse

Executing SQL Queries

Using the Structure and Query tabs of the phpMyAdmin allows you to run multiple queries with semicolons separating the different queries.

phpMyAdmin - Structure Tab

phpMyAdmin - SQL Query Tab

Viewing MySQL Processes

You may view the current MySQL processes by selecting the SQL tab and running the command:

SHOW PROCESSLIST

phpMyAdmin - SQL - Show ProcessList

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

phpMyAdmin - Kill MySQL Process

Performing Operations

Using phpMyAdmin's Operations tab, you can perform different operations on your databases like creating tables, renaming and removing databases, and copying databases.

phpMyAdmin - Operations Tab


Guides to Common Functions in phpMyAdmin

Searches & SQL Queries

Using phpMyAdmin, you can execute queries to manage your databases, like renaming, updating, and retrieving data.

You can do a quick search for information in your database without running advanced queries. Here are helpful articles that will help you perform these tasks.

Database Functions

Many actions can be performed in phpMyAdmin to manage your databases. Among them are moving databases from one server to another and simple actions like renaming and copying databases. Here are helpful articles that you can refer to.

Manipulating Tables

Manually running queries to manage database tables can be a little overwhelming and confusing. To set up your table structure, the phpMyAdmin tool can assist you quickly and easily.

Manipulating Columns

Databases are made up of tables containing rows and columns. Managing these columns is a necessary step to have a functioning database.

You may visit our Database Overview page to see more article links regarding database management.

To know more about common database errors, please refer to this article.