phpMyAdmin is a free, open source web-based database management tool written using PHP programming language. It allows the database administrators to manage single or multiple database servers either from a local or remote system using a web browser. phpMyAdmin used to create, delete, rename, edit databases, tables, fields, and also used to directly execute any SQL commands. Currently, It supports MySQL, MariaDB, and Drizzle database servers.
Installation Commands
sudo apt-get update
sudo apt-get install phpmyadmin php-mbstring php7.0-mbstring php-gettext
During installing, you’ll be asked to choose the web server that should be automatically configured to run phpMyAdmin. In our case, it is Apache webserver.
Choose apache2 and click OK.
Then, edit Apache webserver config file:
sudo nano /etc/apache2/apache2.conf
Add the following line at the end:
Include /etc/phpmyadmin/apache.conf
Save and close the file. Restart apache service to take effect the changes.
sudo service apache2 restart
Open up the web browser and navigate to http://IP-Address/phpmyadmin.
You should see the following screen. Enter the MariaDB/MySQL ‘root’ user name and its password.
