How do I manage a MySQL database in PHPMyAdmin in my control panel (cPanel)?

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!

Please note that sometimes you will want to give a web developer phpMyAdmin access. Instead of giving them your cPanel access data (which is not secure), you can install a separate installation of phpMyAdmin for them so they can access it without having access to cPanel itself. For more help with this, please see:
Installing PHPMyAdmin on your Account

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.

default-phpmyadmin-view

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:

database-view-within-phpmyadmin

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
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Creating an Email Account in cPanel

Login To your cPanel. Once logged into cpanel, click on the "Email Accounts" located in the...

How to log into Webmail

1. After Open an Email Account from cPanel.2. Go To http://yourdomain.com/webmail3. Login with...

How to Create / Delete an FTP Account in cPanel

Creating an FTP Account Login to cPanel. Click the FTP Accounts button in the Files...

How to Change your cPanel Password

Reset Password from cPanel Please note you must know your current cPanel password to change it...

How to Setup an Email Forwarder in cPanel & Webmail

What are Email Forwarders? Email forwarders allow you to send a copy of an email from one email...