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.
- 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).
non-root sudo useror 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
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
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.