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 Ibmi Media, 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
</Directory>

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:

https://your-domain-name/adminer/
## or ###
https://your-server-ip/adminer/

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