This post shows students and new users the steps to install and configure phpMyAdmin on Ubuntu Linux with Nginx 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 will be able to 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 Nginx on Ubuntu Linux
phpMyAdmin needs a web server to work, and Nginx HTTP Server is a great open source server that you can use with phpMyAdmin.
To install Nginx on the Ubuntu server, run the following commands.
sudo apt update sudo apt install nginx
After installing Nginx, the following commands can be used to stop, start and enable Nginx services always start with the server starting.
sudo systemctl stop nginx.service sudo systemctl start nginx.service sudo systemctl enable nginx.service
To find out if Nginx is installed and running, just open your web browser and type in the IP or hostname of the server.