PHP database management tool – Adminer, the alternative to PHPMyAdmin

adminer database management logo

If you think PHPMyAdmin is too heavy for your server, or wish to have a proper web administration tool for your  databases, Adminer is one of the few alternative projects to PHPMyAdmin, that is still under active development.

Indeed, Adminer (formerly known as phpMinAdmin) is a full-featured database management tool written in PHP. The installation is very easy (Single file) while yet powerful enough to support extensive set of databases, such as MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch and also MongoDB.

Available in many languages, Adminer have 5 key development priorities. That are:

  1. Security,

  2. User experience,

  3. Great performance,

  4. Large feature set,

  5. Compact size.

They actually claim to superior in many ways to PHPMyAdmin and you can check their comparison here. Although you may not agree with all their claims, Adminer can be highly customized and is indeed very easy to install (Through your distribution repo or simply by downloading their latest version, available as a single php file!!)

Adminer - Main page screenshot

You can directly check their online demo to give it a try.

And as usual, here is how to install it on your server:


– Installation from your distribution repo:

You can simply install Adminer from the repositories of your distribution. In my case, on Debian 7, I can get the version 3.3.3-1 and to install it, I simply need to run (as root or using sudo)

apt-get install adminer

And you will be able to directly access the web interface through http://YourIP/adminer

– Latest version from the official website

But if you prefer to use the latest version, the installation is still very easy! Only 1 file to donwload.

In your /var/www, you can simply download adminer php’s file. For the v4.1.0, in my case, I will run:

cd /var/www

and then I will have directly access to the adminer web interface through http://myIP/adminer-4.1.0.phpAdminer - LoginEasy to install right?


Loves to discover web-based apps to install on his own server@home and write articles about it


Add a comment