Install phpMyAdmin with Apache on Ubuntu 20.04 - Step by Step Process ?

This article covers how you can  seamlessly install phpMyAdmin on your Ubuntu Linux system.

Working with a database can sometimes be intimidating, but PhpMyAdmin can simplify tasks by providing a control panel to view or edit your MySQL or MariaDB database.

To Install phpMyAdmin on Ubuntu:
1. Update the apt package tool to ensure we are working with the latest and greatest.

$ apt update && upgrade

2. Install PhpMyAdmin and PHP extensions for managing non-ASCII string and necessary tools.

$ apt install phpmyadmin php-mbstring php-gettext

During this installation you’ll be asked for the web server selection, we will select Apache2 and select ENTER.
Here, you have the option for automatic setup or to create the database manually.
For us, we will do the automatic installation by pressing ENTER for yes.
3. At this setup, you'll be asked to set the PhpMyAdmin password.
Specifically for the PhpMyAdmin user, phpmyadmin,  you'll want to save this in a secure spot for later retrieval.
4. Enable PHP extension.

phpenmod mbstring

5. Restart the Apache service to recognize the changes made to the system.

# systemctl restart apache2