Install Adminer on Ubuntu 20.04 LTS - step by step guide ?

Adminer (formerly PHPMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it is a lightweight application with these priorities in order: security, user experience, performance, feature set, and size.

Here at LinuxAPT, as part of our Server Management Services, we regularly help our Customers to perform related Database Management queries.

In this context, we shall look into how to install Adminer on Ubuntu 20.04 LTS.

Steps to Install and configure Adminer on Ubuntu 20.04 LTS Focal Fossa

1. Perform System Update

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

$ sudo apt update
$ sudo apt upgrade

2. Install LAMP stack

If you do not have LAMP installed, you can follow our guide here.

3. Install Adminer on the system

You can Install Adminer by entering the following commands in the terminal:

$ sudo apt install adminer

4. Configure Adminer

Please note that apart from Apache PHP required to run Adminer. To activate the Adminer app run any one of the following commands:

$ sudo a2enconf adminer.conf

The default config file is located at /etc/apache2/conf-enabled/adminer.conf:

$ cat /etc/apache2/conf-enabled/adminer.conf
### Adminer on Ubuntu 20.04 ###
Alias /adminer /etc/adminer
<Directory /etc/adminer>
Require all granted
DirectoryIndex conf.php

Finally, Restart Apache for the changes to take effect using the following command:

$ sudo systemctl reload apache2

How to Access Adminer Web Interface ?

To access the Adminer interface, run the following url on your web browser:

## or ###

[Need assistance in installing any Software on your Linux system ? We can help you. ]

This article covers the process of installing Adminer on your Ubuntu 20.04 LTS Focal Fossa system. In fact, Adminer is an alternative to phpMyAdmin that works from a single PHP file and it's easy to install. It supports databases like MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB, SimpleDB (plugin), Firebird (plugin), ClickHouse, and more.

To install Adminer on your Linux system, simply run the below commands:

$ sudo apt update
$ sudo apt upgrade
$ sudo apt install adminer

Related Posts