Manage MySQL / MariaDB & PostgreSQL Database Server using Adminer

Posted on 220 views

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 https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.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-1024x467

Input database access details.

install-adminer-database-management-tool-02-1024x429

You should get to a dashboard similar to this:

install-adminer-database-management-tool-03-1024x459

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

coffee

Gravatar Image
A systems engineer with excellent skills in systems administration, cloud computing, systems deployment, virtualization, containers, and a certified ethical hacker.