Install and Configure phpMyAdmin on Ubuntu

To get started, we can simply install phpMyAdmin from the default Ubuntu repositories.

We can do this by updating our local package index and then using the apt packaging system to pull down the files and install them on our system:

sudo apt-get update
sudo apt-get install phpmyadmin
 Edit the apache2.conf file by entering the below command.
Type  vim /etc/apache2/apache2.conf

Add the following to the bottom of the file:

# phpMyAdmin Configuration

Include /etc/phpmyadmin/apache.conf

Then exit and save the file with the command :wq.

And, restart Apache 2 with the following command:

service apache2 restart

You should now have phpMyAdmin configured and ready to use on your Ubuntu server. Using this interface, you can easily create databases, users, tables, etc., and perform the usual operations like deleting and modifying structures and data.