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.
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
To access the Adminer interface, run the following url on your web browser:
https://your-domain-name/adminer/
## or ###
https://your-server-ip/adminer/
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