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. Typevim /etc/apache2/apache2.conf
Add the following to the bottom of the file:
# phpMyAdmin Configuration
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.