How to Get phpMyAdmin on Ubuntu 20.04 LTS

How to Get phpMyAdmin on Ubuntu 20.04 LTS

phpMyAdmin is a free and open-source tool written in PHP for managing MySQL and MariaDB databases. It provides a user-friendly web interface for managing databases, tables, fields, relations, indexes, users, permissions, and more. It also allows you to execute SQL queries, import and export data, and backup and restore databases. In this article, we will show you how to install and configure phpMyAdmin on Ubuntu 20.04 LTS.


Before you start, you need to have the following:

  • An Ubuntu 20.04 LTS server
  • A sudo user
  • A web server (Apache or Nginx)
  • MySQL or MariaDB server

Steps to Get phpMyAdmin on Ubuntu 20.04 LTS

Follow the below steps to install phpMyAdmin on Ubuntu 20.04 LTS:

Step 1: Update the system

Before installing any package, it is recommended to update the system packages to the latest version. You can do this by running the following command:

sudo apt update && sudo apt upgrade

Step 2: Install phpMyAdmin

phpMyAdmin is available in the Ubuntu package repository. You can install it by running the following command:

sudo apt install phpmyadmin

During the installation, you will be prompted to choose the web server that should be automatically configured to run phpMyAdmin. Choose the web server that you have installed on your system. If you have not installed a web server, you can install it by running the following command:

See also  How to Move Down Google Chrome Address Bar on Android: Easy Guide

sudo apt install apache2

Step 3: Configure the web server

After installing phpMyAdmin, you need to configure the web server to serve the phpMyAdmin application. If you have installed Apache, create a new configuration file for phpMyAdmin by running the following command:

sudo nano /etc/apache2/conf-available/phpmyadmin.conf

Add the following lines to the file:

Alias /phpmyadmin /usr/share/phpmyadmin
<Directory /usr/share/phpmyadmin>
    Options FollowSymLinks
    DirectoryIndex index.php
    AllowOverride All

Save and close the file. Then, enable the configuration file by running the following command:

sudo a2enconf phpmyadmin

Finally, restart the Apache web server by running the following command:

sudo systemctl restart apache2

Step 4: Access phpMyAdmin

phpMyAdmin is now installed and configured on your Ubuntu 20.04 LTS server. You can access it by opening a web browser and navigating to the following URL:


You will be prompted to enter the username and password for the MySQL or MariaDB server. Enter the credentials and click on the Go button. You will then be redirected to the phpMyAdmin dashboard, where you can manage your databases and tables.

Features of phpMyAdmin

phpMyAdmin provides the following features:

  • User-friendly web interface
  • Database and table management
  • Field and relation management
  • Index and key management
  • User and permission management
  • SQL query execution
  • Data import and export
  • Database backup and restore
  • Multi-language support
  • Theme customization

Pros and Cons of phpMyAdmin

phpMyAdmin has the following pros and cons:


  • Free and open-source
  • User-friendly interface
  • Powerful database management features
  • Supports multiple database servers
  • Highly customizable


  • May not be suitable for large-scale databases
  • May have security vulnerabilities if not properly configured
See also  Best Hacking Apps for iOS and iPhone: Complete Guide

What is MySQL?

MySQL is an open-source relational database management system (RDBMS) that uses SQL (Structured Query Language) for managing data. It is widely used for web applications, business applications, and embedded systems. MySQL is developed, distributed, and supported by Oracle Corporation.

What is MariaDB?

MariaDB is a community-driven fork of MySQL that is compatible with MySQL and offers additional features and performance improvements. It is developed, distributed, and supported by the MariaDB Foundation.

Comparison Table

Here is a comparison table between MySQL, MariaDB, and phpMyAdmin:

Product Description Features Pros Cons
MySQL Relational database management system SQL support, ACID compliance, replication, clustering, partitioning Widely used, stable, scalable, secure Owned by Oracle, may have licensing issues
MariaDB Community-driven fork of MySQL SQL support, ACID compliance, replication, clustering, partitioning, additional features Compatible with MySQL, faster than MySQL, more secure than MySQL May have compatibility issues with MySQL, may have less support than MySQL
phpMyAdmin Web-based database management tool Database and table management, SQL queries, data import and export, backup and restore Free and open-source, user-friendly, powerful features May not be suitable for large-scale databases, may have security vulnerabilities


Q: What is the default username and password for phpMyAdmin?

A: The default username for phpMyAdmin is “root” and the default password is blank. However, it is recommended to set a strong password for the root user for security reasons.

Q: How can I change the phpMyAdmin theme?

A: You can change the phpMyAdmin theme by clicking on the “Theme” dropdown menu on the top right corner of the dashboard and selecting a theme from the list.

See also  How to Make Multiboot USB with Ventoy


phpMyAdmin is a powerful and user-friendly web-based database management tool that can help you manage your MySQL or MariaDB databases on Ubuntu 20.04 LTS. By following the above steps, you can easily install and configure phpMyAdmin on your Ubuntu server and start managing your databases and tables with ease. However, it is important to properly secure and maintain your databases to prevent any security issues.

Himanshi Tyagi
We will be happy to hear your thoughts

Leave a Reply

Trickbugs: Tips and Tutorials