---
title: "Becoming familiar with databases and phpMyAdmin"
type: "knowledge"
post_id: "2339"
slug: "becoming-familiar-with-databases-and-phpmyadmin"
canonical: "https://kb.easydns.com/knowledge/becoming-familiar-with-databases-and-phpmyadmin/"
markdown_url: "https://kb.easydns.com/knowledge/becoming-familiar-with-databases-and-phpmyadmin.md"
json_url: "https://kb.easydns.com/knowledge/becoming-familiar-with-databases-and-phpmyadmin.json"
txt_url: "https://kb.easydns.com/knowledge/becoming-familiar-with-databases-and-phpmyadmin.txt"
published: "2018-07-12T16:29:05+00:00"
modified: "2020-06-09T11:57:30+00:00"
author: "ryan"
categories:
tags:
site_name: "easyDNS Knowledge Base"
publisher: "easyDNS Technologies Inc."
language: "en-US"
generator: "easyPress Markdown"
generator_version: "1.0.6"
---
Becoming familiar with databases and phpMyAdmin

 This video assumes you’ve already logged in to phpMyAdmin.

 Now let’s familiarize ourselves with databases and phpMyAdmin.

 phpMyAdmin allows us to have complete access to the MySQL **databases** in our account.

 The databases are listed here in the left pane.

 Databases consist of one or more **tables**, and it is within these tables that database information (or data) is stored.

 This particular database has one table, and it’s called **details**.

 When we click on a database name in the left pane, we can see more information about the tables within the database in the right pane.

 We can browse a table to see the individual records…

 … we can see the structure of a table and perform certain actions…

 … we can search through a table for specific keywords…

 … we can insert new rows (or fields) into a table…

 … we can delete the contents of a table…

 … or we can delete (or drop) an entire table altogether.

 We can alternatively click the **Structure** tab to view the database structure…

 … click the **SQL** tab if we want to enter direct queries to the database…

 … click the **Search** tab to perform a search…

 … Import or export databases or tables…

 … and several other operations.

 Now let’s take a closer look at the details table. Click the table name in the left pane, then click the **Structure** tab.

 The structure of a table lists all teh table’s fields, along with the type of fields and other information.

 We can also see which field within the table is the Primary Key field.

 If you ever need additional help, you can access either phpMyAdmin or MySQL documention by clicking the appropriate help icon here.

 Click the **Home** icon to return to the home page of your phpMyAdmin.

 This is the end of the tutorial. You should now be more familiar with databases, and how to use phpMyAdmin to access them.