Install phpMyAdmin on Ubuntu 16.04
phpMyAdmin is the most popular and most widely used web-based database management tools. It a free and open source PHP application, that allows the users to manage single or multiple SQL database servers, locally or on a remote server using a web browser with easy to use graphic user interface.
Many developers needs to interact and manipulate with their databases, but not all of them are comfortable with SQL commands, and this is where phpMyAdmin comes in hand. You e can easily create, rename, delete and edit databases, tables or fields, execute SQL commands. You can easily import and export tables, create and modify users, and so on, all via an easy-to-use GUI. Installing phpMyAdmin on Ubuntu 16.04, is an easy task if you carefully follow the steps bellow. Let’s get started with the installation of phpMyAdmin on your Ubuntu 16.04 server.
1. Login via SSH
Login to Ubuntu 16.04 Virtual Machine via SSH and make sure that you have the latest version of all installed packages.
sudo apt-get update && sudo apt-get upgrade
2. Install Apache, PHP and MySQL
Follow this tutorial to install the same.
3. Install phpMyAdmin on Ubuntu 16.04
Once Apache, PHP and MySQL are installed, we can go ahead and install phpMyAdmin. The package is included in the official Ubuntu 16.04 repository and it can be easily installed with the command below
sudo apt-get install phpmyadmin
phpMyAdmin will be installed along with its dependencies and all necessary PHP modules.
When you will be prompted to select a web server to configure, hit the space bar to select Apache2 and Enter to confirm and continue.
On the next screen, select YES to configure a database for phpMyAdmin with dbconfig-common.
4. Set the Password for the phpMyAdmin User
and finally set a password for the ‘phpmyadmin’ user in MySQL
With this step, the installation of phpMyAdmin is completed.
5. Test and Verify phpMyAdmin Installation on Ubuntu 16.04
You can access it at http://yourIPaddress/phpmyadmin and login with your MySQL username and password.