How To Install Adminer on Ubuntu 22.04 LTS

In this tutorial, we will show you how to install Adminer on Ubuntu 22.04 LTS. For those of you who didn’t know, Adminer (formerly known as PHPMyAdmin) is an open-source and free web-based database management tool. With Adminer, you can manage several databases including, MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB, and more. it is a lightweight application with strong security and user experience in mind.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step installation of the Adminer on Ubuntu 22.04 (Jammy Jellyfish). You can follow the same instructions for Ubuntu 22.04 and any other Debian-based distribution like Linux Mint, Elementary OS, Pop!_OS, and more as well.

Prerequisites

• A server running one of the following operating systems: Ubuntu 22.04, 20.04, and any other Debian-based distribution like Linux Mint.
• It’s recommended that you use a fresh OS install to prevent any potential issues.
• SSH access to the server (or just open Terminal if you’re on a desktop).
• A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Install Adminer on Ubuntu 22.04 LTS Jammy Jellyfish

Step 1. First, make sure that all your system packages are up-to-date by running the following apt commands in the terminal.

sudo apt update
sudo apt upgrade
sudo apt install lsb-release ca-certificates apt-transport-https software-properties-common

Step 2. Installing LAMP Stack on Ubuntu.

Before starting this tutorial, the LAMP server must be installed on your server. If you do not have LAMP Stack installed, you can follow our guide here.

Step 3. Installing Adminer on Ubuntu 22.04.

By default, the Adminer is available on Ubuntu 22.04 base repository. Now run the following command below to install the latest version of Adminer to your Ubuntu system:

sudo apt install adminer

Step 4. Configuring Apache for Adminer.

To activate the Adminer app run any one of the following a2enconf commands:

sudo a2enconf adminer

After that, reload Apache through the command below:

 sudo systemctl reload apache2

Step 5. Configure Firewall.

Ubuntu 22.04 has ufw a firewall running by default. Enable connection through ports 80 HTTP and 443 HTTPS:

sudo ufw allow 'Apache Full'
sudo ufw enable
sudo ufw status

Step 6. Accessing Adminer Web Interface.

Once successfully installed, open your web browser and type the URL https://your-server-ip-address/adminer/. You will be redirected to the Adminer dashboard interface:

Congratulations! You have successfully installed Adminer. Thanks for using this tutorial for installing the Adminer database management on Ubuntu 22.04 LTS Jammy Jellyfish system. For additional help or useful information, we recommend you check the official Adminer website.