Installing phpMyAdmin in Ubuntu 16.04
phpMyAdmin is an open source tool used for the administration/management of MySQL or MariaDB with the use of a web browser. In addition to offering the capability to perform administration tasks such as creating, editing, or deleting databases, and managing users and permissions, phpMyAdmin provides a graphical user interface to do all of these tasks and more. Here, we are going to see how to install, up and run phpMyAdmin on Ubuntu 16.04.
Install phpMyAdmin
Before you start installing phpmyadmin, install PHP, apache and MySql or similar Db..
Then.. Run following command .. to install phpMyadmin on your Ubuntu installation...
sudo apt -y update && sudo apt install phpmyadmin
Continue with typing Y once the installation prompts you with Do you want to continue [Y/n]? Like in the image below.
Now we are prompted with dialog selecting our web server, in our case we are selecting apache2 like shown below.
Select <Yes> as we just want a basic installation like shown below.
Now provide a password for phpMyAdmin to use. So that it can register with the MySQL database itself. (Need not to be the same as the MySQL root user)
Enter in the phpMyAdmin password you created in last step to confirm it as follows.
phpMyAdmin is now installed, but, still we have a few more things to do.
Testing phpMyAdmin
Now we will test phpMyAdmin! Open your favorite Web Browser..
and Navigate to http://localhost/phpmyadmin/
If you end up with a page that looks like one shown below... means, phpMyadmin was installed successfully on your system..
Now lets login, the default username for phpMyAdmin is root and the password is what you have entered while installing phpMyadmin... Enter as follows.
Username: root Password: What you selected earlier Select Go to login.
When you log in, you'll see the user interface, which will look something like this: