Click here to watch a video tutorial

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. For more help with creating a database, please see:
How do I create a MySQL database in my control panel?

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!

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:

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve our Support Center:
Email Address
Optional, but our team may contact you for more information.
Like this Article?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!