Here is a quick and easy install guide for phpMyAdmin on Ubuntu 16.04 if you have LAMP setup which is Apache, MYSQL and PHP. phpMyAdmin is a web app for database management and interaction.
The first step is to update and download the phpMyAdmin from the default Ubuntu repositories:
sudo apt-get update sudo apt-get install phpmyadmin
Choose apache2 for the server selection
Yes for dbconfig-common
asking to set up the database.
You will be asked for the database administrator password and then asked to set the phpMyAdmin username and password.
Next enable the extension php5-mcrypt
:
sudo php5enmod mcrypt
Restart apache:
sudo service apache2 restart
And that’s it, you can now access phpMyAdmin by going to:
http://YOURIPorDOMAIN/phpmyadmin
Replacing YOURIPorDOMAIN with your servers ip address or the domain if it is associated with the ip.