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.

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)

Install Adminer on Linux

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

Step 1: Install PHP

----- Install PHP on Ubuntu / Debian ------
$ 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.

export VER="4.7.4"
sudo wget -O /var/www/html/adminer.php https://github.com/vrana/adminer/releases/download/v${VER}/adminer-${VER}.php

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

Input database access details.

You should get to a dashboard similar to this:

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

Similar guides:

Install phpMyAdmin on Debian

Install phpMyAdmin on Fedora

Install phpMyAdmin on CentOS 8

Install phpMyAdmin on Ubuntu