Admirer is a free and open source Database management system that is packaged in a single PHP file. This guide will discuss how you can install and use Adminer to manage MySQL, MariaDB and PostgreSQL database servers. Admirer has supports for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB, Firebird e.t.c. We will look at the installation and use of Adminer to manage MySQL / MariaDB & PostgreSQL Database Server on a Linux system.

You can replace phpMyAdmin with Adminer and enjoy its simple and intuitive user interface. See phpMyAdmin vs Adminer page. The only requirement of Admirer is PHP 5/7 with enabled sessions.

Features of Adminer Database Management Tool

Here are the standard features of Admirer.

  • Connect to a database server with username and password
  • Select an existing database or create a new one
  • List fields, indexes, foreign keys and triggers of table
  • Change name, engine, collation, auto_increment and comment of table
  • Alter name, type, collation, comment and default values of columns
  • Add and drop tables and columns
  • Create, alter, drop and search by indexes including fulltext
  • Create, alter, drop and link lists by foreign keys
  • Create, alter, drop and select from views
  • Create, alter, drop and call stored procedures and functions
  • Create, alter and drop triggers
  • List data in tables with search, aggregate, sort and limit results
  • Insert new records, update and delete the existing ones
  • Supports all data types, blobs through file transfer
  • Execute any SQL command from a text field or a file
  • Export table structure, data, views, routines, databases to SQL or CSV
  • Print database schema connected by foreign keys
  • Show processes and kill them
  • Display users and rights and change them
  • Display variables with links to documentation
  • Manage events and table partitions (MySQL 5.1)
  • Schemas, sequences, user types (PostgreSQL)

How To Install Adminer Database Manager on Linux

Adminer requires PHP, let’s ensure it is installed in our system.

Step 1: Install PHP on Linux system

### Install PHP on Ubuntu / Debian ###
sudo apt update
sudo apt -y install php php-common php-pear php-mbstring libapache2-mod-php php-mysql

### Install PHP on CentOS / Fedora ###
sudo yum -y install php php-pear php-mbstring php-mysqlnd

Once PHP is installed, download Adminer php script.

Step 2: Install Apache Web Server

We’ll use Apache httpd web server to host Adminer on Linux.

### Install Apache on Ubuntu / Debian ###
sudo apt -y install apache2 wget
sudo systemctl enable --now wget

### Install Apache on CentOS / Fedora ###
sudo yum -y install httpd wget
sudo systemctl enable --now httpd

Step 3: Install Adminer on Linux – Ubuntu / Debian / CentOS / Fedora

Now download the latest Adminer PHP script and place it in your Web document root.

sudo wget -O /var/www/html/adminer.php

Access Adminer Dashboard on http://serverip/adminer.php. Connect to your database by selecting the type on the dropdown menu.

install adminer database management tool 01

Input database access details.

install adminer database management tool 02

You should get to a dashboard similar to this:

install adminer database management tool 03

A supported PHP extension is required when connecting to a database backend.

Best Udemy Video Courses to Learn MySQL / MariaDB Databases:

Best Video courses to Learn PostgreSQL Database:

Similar guides:

Install phpMyAdmin on Debian

Install phpMyAdmin on Fedora

Install phpMyAdmin on CentOS 8

Install phpMyAdmin on Ubuntu

Your support is our everlasting motivation,
that cup of coffee is what keeps us going!

As we continue to grow, we would wish to reach and impact more people who visit and take advantage of the guides we have on our blog. This is a big task for us and we are so far extremely grateful for the kind people who have shown amazing support for our work over the time we have been online.

Thank You for your support as we work to give you the best of guides and articles. Click below to buy us a coffee.


Please enter your comment!
Please enter your name here