According to phpMyAdmin’s official site, phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB.
phpMyAdmin is an open source tool written in php and is used for administration of MySQL and MariaDB. phpMyAdmin provides a very simple and intuitive user interface to accomplish these tasks.
Installing phpMyAdmin
To install phpMyAdmin, LAMP (Linux, Apache, MySQL and PHP stack) server must be installed on your Desktop/Server. If you haven’t installed LAMP yet, you can follow our tutorial on How to Install LAMP Server on Ubuntu 16.04/17.04 Desktop Using Tasksel.
Before we begin with installation, it is good if we update the list of available packages by running following commond.
sudo apt-get update
Once the lists are updated and upgrades are done (if there are any available), then run following command to install install phpMyAdmin.
sudo apt-get install phpmyadmin
It will ask to configure database, select Yes and hit Enter. Then it will prompt you to enter the password to register phpMyAdmin with database server, enter the desired password and confirm it in the next prompt.
After confirming the password, the next prompt will be for selecting web server, move cursor to apache2 using arrow keys and press spacebar to select it, press tab to move the curser to ok, and hit enter.
Restart Apache using below command
sudo service apache2 restart
or
sudo /etc/init.d/apache2 restart
And you are done, now you can access phpMyAdmin by visiting http://localhost/phpmyadmin in your web browser.
