phpMyAdmin is a free software tool written in PHP to handle the administration of MySQL over a web interface, instead of managing databases, tables, columns, relations, indexes, users, permissions, etc directly from MySQL console interface.
Why do we need phpMyAdmin?
Once you wanted to host your web application on your server or you want to develop your web application, you might need to manage your MySQL databases. So, this is a great tool with a great GUI which is helping you to manage your databases without executing command through MySQL command line interface.
Before you want to start this tutorial, you might need to knwo how to run your web server (LAMP Server). Here is the step by step guide to install and run LAMP server on Ubuntu Server 18.04
In order to complete this tutorial, you need to know basic knowledge about Linux Terminal. We are using Ubuntu Server 18.04 in our training guide and all the further commands are provided for the mentioned version
To install phpMyAdmin, First of all we need to update our repository and then we can install phpMyAdmin from the default repositories using apt command:
sudo apt-get update sudo phpmyadmin php-mbstring php-gettext -y
During the installation proccess you it will ask you some question to configure phpMyAdmin. First, it will ask you to select your web server. Highlight the apache2 and press Space key to select it, then press Tab key to highlight Ok and then press Enter.dbconfig-common to set up the database. Select Yes.
Now, you can check your phpMyAdmin installation by opening this URL http://your-server-ip-address/phpmyadmin. In my case my server ip address is "192.168.59.10". So, i need to open "http://192.168.59.10/phpmyadmin" URL in my web browser.
You need to login to phpMyAdmin using MySQLroot account. It's not recommended to use this account in the production environment.
Once you log in, you can manage your MySQL databases using this great tool.