This post shows students and new users the steps to install and configure phpMyAdmin on Ubuntu Linux with Apache support. phpMyAdmin is an open source web tool that allows users to easily manage MySQL or MariaDB databases from their favorite web browsers.
Traditionally, users typically connect to the console of a database server and run queries and commands to manage databases, user permissions, and other tasks. However, for those who are not comfortable using the command line interface to manage databases, the phpMyAdmin web interface is a great alternative.
With phpMyAdmin, you can manage MySQL databases, user accounts and privileges, execute SQL statements, import and export data in a variety of data formats, and much more.
To start installing phpMyAdmin, continue with the steps below:
How to install Apache on Ubuntu Linux
phpMyAdmin needs a web server to work, and Apache HTTP Server is a great open source server that you can use with phpMyAdmin.
To install Apache on the Ubuntu server, run the following commands.
sudo apt update sudo apt install apache2
After installing Apache, the following commands can be used to stop, start and enable Apache services always start with the server starting.
sudo systemctl stop apache2.service sudo systemctl start apache2.service sudo systemctl enable apache2.service
To find out if Apache is installed and running, just open your web browser and type in the IP or hostname of the server.