How do I manage MySQL Databases using PhpMyAdmin in cPanel?

Managing a MySQL database in PHPMyAdmin

In this article, we'll give a brief introduction to phpMyAdmin, a web based mySQL client you can use to manage your databases. There are many tools and features that phpMyAdmin includes, but in this article we're only going to cover a few basics.

Before you can manage a database within phpMyAdmin, you must first create the database. After you have created the database, you can now access the database within phpMyAdmin.

How to log into phpMyAdmin

To log into phpMyadmin:

  1. Log into your cPanel
  2. Click the phpMyAdmin icon under the "Databases" heading.
  3. Congratulations, you are now logged into phpMyAdmin!

What am I looking at when I log into phpMyAdmin?

When you first log into phpMyAdmin, you'll see quite a bit of data. For most basic tasks, you'll select a database in the left menu (see screenshot below) and then begin to manage that individual database.

Besides a list of databases in the left menu, there are server details and configuration settings in the middle and right side of the page, but we will not cover those in this article.

Selecting a Database

If you click on a database in the left column, it will then load more information specific to that database:

 

In the left menu, it now shows a listing of all of the tables in the database. If you click any of the tables, it will allow you to view and manage the data in each of those tables.

In the top menu, you'll see various options for the database you're working with, such as:

  • Structure
  • SQL
  • Search
  • Query
  • Export
  • Import
  • Operations
  • 32 Users Found This Useful
Was this answer helpful?

Related Articles

How to import database via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...

How to add a user to a database and add privileges?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

Can I connect to SQL database using SQL Server Management Studio?

Yes, you can use Microsoft SQL Server Management Studio to remotely connect with your database on...

How to rename a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

[PLESK 11] How to Backup and Restore Microsoft SQL Server Database

This article applies to PLESK 11 Following are the steps to Get backup and Restore the...