Topic 34 of 56 · Full Stack Advanced

Introduction to phpMyAdmin

Lesson TL;DRTopic 1: Introduction to phpMyAdmin 📖 5 min read · 🎯 beginner · 🧭 Prerequisites: introduction, introductionandfoundation Why this matters Here's the thing — every web app you build will eventually ...
5 min read·beginner·phpmyadmin · mysql · mariadb · database

Topic 1: Introduction to phpMyAdmin

📖 5 min read · 🎯 beginner · 🧭 Prerequisites: introduction, introduction-and-foundation

Why this matters

Here's the thing — every web app you build will eventually need to store data: user accounts, product listings, form submissions. That data lives in a database, and at some point you need to look inside it, fix a mistake, or check if your code actually saved what you thought it did. You could type raw SQL commands in a terminal, but that's a steep learning curve when you're just starting out. phpMyAdmin gives you a clean, visual interface in the browser to manage your MySQL or MariaDB database — no memorizing commands, just point and click. That's what we're learning today.

What You'll Learn

  • What phpMyAdmin is and why it exists
  • How to install and configure phpMyAdmin on a web server
  • How to navigate the phpMyAdmin interface
  • How to create databases, tables, and insert records through the UI
  • How to use advanced features: SQL queries, import/export, and user management

The Analogy

Think of your database server as a vast municipal archive building — every city record, permit, and census sheet filed somewhere inside. Without a guide, finding or changing a single record means wandering endless stacks in the dark. phpMyAdmin is the head archivist: it knows exactly where every shelf is, hands you a clipboard to write search requests on, and lets you add, edit, or remove files without ever having to memorize the building's internal numbering system. You still need to understand what you're asking for — but the archivist handles the mechanics so you can focus on the work.

Chapter 1: What Is phpMyAdmin?

phpMyAdmin is a free, open-source administration tool written in PHP. It provides a browser-based graphical interface for managing MySQL and MariaDB databases — no command-line required for day-to-day tasks.

With phpMyAdmin you can:

  • Browse and manage databases
  • Execute SQL queries through an interactive query box
  • Manage database users and set permissions
  • Import and export data in multiple formats
  • Create and modify tables, fields, and indexes

Because it runs entirely in a web browser, the same interface works whether the database lives on your laptop or a remote cloud server.

Chapter 2: Setting Up phpMyAdmin

Prerequisites

You need a running MySQL or MariaDB server before phpMyAdmin has anything to connect to. Confirm it is installed and accepting connections before proceeding.

Installation Steps

1. Install MySQL or MariaDB

# Ubuntu / Debian
sudo apt update && sudo apt install mysql-server -y

# macOS with Homebrew
brew install mysql

2. Download phpMyAdmin

Visit the official phpMyAdmin website and download the latest stable release archive.

3. Unpack into your web root

sudo tar -xzf phpMyAdmin-*-all-languages.tar.gz -C /var/www/html/
sudo mv /var/www/html/phpMyAdmin-*-all-languages /var/www/html/phpmyadmin

4. Configure phpMyAdmin

cd /var/www/html/phpmyadmin
cp config.sample.inc.php config.inc.php

Open config.inc.php and make the following edits:

// Set a random 32-character string for cookie encryption
$cfg['blowfish_secret'] = 'a8b3f2c9d1e4g7h0j5k6l2m8n3o1p9q4';

// Define the database server phpMyAdmin should connect to
$cfg['Servers'][$i]['host']          = '127.0.0.1';
$cfg['Servers'][$i]['auth_type']     = 'cookie';   // login form in the browser
$cfg['Servers'][$i]['AllowNoPassword'] = false;

5. Access phpMyAdmin

Open your browser and navigate to:

http://localhost/phpmyadmin

Log in with your MySQL username and password. If you see the dashboard, you are in.

Chapter 3: Navigating the Interface

Once logged in, three main regions define the phpMyAdmin workspace:

  1. Left Sidebar — Database List: Lists every database on the server. Clicking a database expands it to show its tables. Clicking a table brings up that table's data and options.

  2. Top Bar — SQL Query Box: A text area where you can type and run raw SQL commands against the currently selected database or table.

  3. Tab Row — Operations Panel: When you select a database or table, a row of tabs appears. The most important ones are:

TabPurpose
StructureView and modify columns, indexes, and keys
SQLExecute custom SQL on this object
SearchQuery rows using form fields
ExportDownload the data or schema as SQL, CSV, JSON, etc.
ImportUpload a SQL or CSV file to populate the table

Chapter 4: Managing Databases and Tables

Creating a Database

  1. Click the "New" link at the top of the left sidebar.
  2. Enter a name for the database in the text field.
  3. Select a collation (character set) — utf8mb4_unicode_ci is a safe default for multilingual data.
  4. Click "Create".

Creating a Table

  1. Select your database from the sidebar.
  2. Click the "Structure" tab.
  3. Enter the table name and the number of columns you want to start with.
  4. Click "Go" to open the column definition form.
  5. Define each column — for example:
id      INT          AUTO_INCREMENT  PRIMARY KEY
name    VARCHAR(100) NOT NULL
email   VARCHAR(150) NOT NULL
created TIMESTAMP    DEFAULT CURRENT_TIMESTAMP
  1. Click "Save" to create the table.

Inserting Data

  1. Select the table from the sidebar.
  2. Click the "Insert" tab.
  3. Fill in the value for each column field in the form.
  4. Click "Go" — phpMyAdmin will run the INSERT statement and confirm the row was added.

Chapter 5: Advanced Features

Running SQL Queries Directly

The SQL tab accepts any valid SQL command. This is useful for bulk updates, joins, or anything the UI forms do not expose:

SELECT id, name, email
FROM users
WHERE created > '2024-01-01'
ORDER BY name ASC;

Results appear in a sortable, paginated table below the query box.

Exporting and Importing Data

Export: Select a database or table → click Export → choose format (SQL for full backups, CSV for spreadsheet exchange) → click Go. A file downloads to your machine.

Import: Click Import → choose your .sql or .csv file → set the character set to utf-8 → click Go. phpMyAdmin executes each statement in the file sequentially.

User Management

Navigate to User Accounts from the top navigation bar. From here you can:

  • Create new database users with specific usernames and hosts
  • Grant or revoke privileges (SELECT, INSERT, UPDATE, DELETE, ALL PRIVILEGES) at the database or table level
  • Change passwords and remove accounts
-- Equivalent SQL phpMyAdmin generates under the hood
CREATE USER 'app_user'@'localhost' IDENTIFIED BY 'StrongPassword!9';
GRANT SELECT, INSERT, UPDATE, DELETE ON myapp.* TO 'app_user'@'localhost';
FLUSH PRIVILEGES;

Chapter 6: Troubleshooting and Security Tips

Error Handling

phpMyAdmin surfaces descriptive error messages directly below the query box. The message includes the MySQL error code (e.g., #1045 Access denied) and the offending SQL fragment. Read the message, look up the error code in the MySQL docs if needed, and correct the query or credentials.

Security Hardening Checklist

  • Use strong passwords for all MySQL accounts, especially root.
  • Restrict access by IP: Configure your web server (Apache/Nginx) to allow /phpmyadmin only from trusted IP addresses.
  • Keep phpMyAdmin updated: Security vulnerabilities are patched in each release; run the latest stable version.
  • Disable root login via phpMyAdmin: Create a dedicated, limited-privilege user for application access instead of using root.
  • Use HTTPS: Never expose phpMyAdmin over plain HTTP on a networked server. Terminate SSL at the web server level.

🧪 Try It Yourself

Task: Create a blog database with a posts table that stores article data.

  1. Log into phpMyAdmin at http://localhost/phpmyadmin.
  2. Create a database named blog with collation utf8mb4_unicode_ci.
  3. Inside blog, create a table named posts with these columns:
id        INT           AUTO_INCREMENT  PRIMARY KEY
title     VARCHAR(255)  NOT NULL
body      TEXT          NOT NULL
author    VARCHAR(100)  NOT NULL
published TINYINT(1)    DEFAULT 0
created   TIMESTAMP     DEFAULT CURRENT_TIMESTAMP
  1. Use the Insert tab to add one row: any title, a short body, your name as author, and published = 1.
  2. Click the Browse tab.

Success criterion: You should see your row listed in a table with all six columns populated and created auto-filled with the current timestamp.

🔍 Checkpoint Quiz

Q1. phpMyAdmin is written in which language, and which two database engines does it primarily support?

A) JavaScript — PostgreSQL and SQLite B) PHP — MySQL and MariaDB C) Python — MySQL and Oracle D) Ruby — MariaDB and CockroachDB

Q2. A developer renames config.sample.inc.php to config.inc.php and opens it. Which configuration value must they set to enable secure cookie-based authentication?

A) $cfg['Servers'][$i]['host'] B) $cfg['blowfish_secret'] C) $cfg['DefaultLang'] D) $cfg['Servers'][$i]['auth_type']

Q3. Given this column definition entered in phpMyAdmin's table creation form:

id INT AUTO_INCREMENT PRIMARY KEY

What will happen when you insert a new row without specifying a value for id?

A) The insert will fail with a NOT NULL violation B) The column will be set to 0 every time C) MySQL will automatically assign the next sequential integer D) The column will be set to NULL

Q4. Your team needs to give a new application read and write access to the shop database, but must not allow it to delete tables or manage other users. Which phpMyAdmin tab would you use, and which privileges would you grant?

A1. B — phpMyAdmin is written in PHP and targets MySQL and MariaDB; the other combinations are incorrect engine/language pairings.

A2. B — $cfg['blowfish_secret'] is a random 32-character string used to encrypt the authentication cookie. Without it phpMyAdmin will warn you or refuse to store sessions securely.

A3. C — AUTO_INCREMENT instructs MySQL to track the highest existing value for that column and assign the next integer automatically on every insert.

A4. Use the User Accounts tab. Create (or edit) the user and grant SELECT, INSERT, UPDATE, and DELETE on shop.* only — do not grant DROP, CREATE USER, or GRANT OPTION. This gives read/write access without structural or administrative power.

🪞 Recap

  • phpMyAdmin is a free, PHP-based web interface for administering MySQL and MariaDB databases without the command line.
  • Installation requires placing phpMyAdmin in the web root and editing config.inc.php to set the blowfish secret and server connection details.
  • The left sidebar lists databases and tables; the tab row exposes Structure, SQL, Search, Export, and Import operations for each object.
  • You can create databases, define tables with typed columns, and insert rows entirely through form-based UI.
  • Advanced use includes raw SQL execution, data import/export, and fine-grained user privilege management.

📚 Further Reading

Like this topic? It’s one of 56 in Full Stack Advanced.

Block your seat for ₹2,500 and join the next cohort.

Course detailsBlock your seat →