How To install Adminer on Ubuntu 16.04

To install Adminer on Ubuntu 16.04

Adminer is a database management tool with a clear and consistent user interface. It is built based on PHP and is a very similar to PHPMyAdmin functionality. It is very lightweight, but at the same time, it is also very powerful. It is developed to improve security, user experience, performance etc. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle. In this tutorial, you will learn about the method to install Adminer on Ubuntu 16.04

Pre-requisite
Install LAMP (apache, php , mariadb-server)

In mariadb (create database , user and give privilages to user)

Php modules (apt install php libapache2-mod-php php-curl php-cli php-mysql php-gd)

Installing Adminer

Before you begin with the process, make sure you create a new directory for adminer as follows.

root@linuxhelp:~# mkdir /usr/share/adminer

Now you shall download Adminer package and save it in the newly created directory.

root@linuxhelp:~#  wget " https://www.adminer.org/latest.php"  -O /usr/share/adminer/latest.php
--2017-11-20 18:59:45--  https://www.adminer.org/latest.php
Resolving www.adminer.org (www.adminer.org)... 54.79.123.29
Connecting to www.adminer.org (www.adminer.org)|54.79.123.29|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: static/download/4.3.1/adminer-4.3.1.php [following]
--2017-11-20 19:00:12--  https://www.adminer.org/static/download/4.3.1/adminer-4.3.1.php
Reusing existing connection to www.adminer.org:443.
HTTP request sent, awaiting response... 200 OK
Length: 436227 (426K) [application/octet-stream]
Saving to: ‘ /usr/share/adminer/latest.php’ 

/usr/share/adminer/l 100%[====================> ] 426.00K  76.5KB/s    in 5.6s    

2017-11-20 19:00:18 (76.5 KB/s) - ‘ /usr/share/adminer/latest.php’  saved [436227/436227]

And then, create a symbolic link for latest.php by making use of the following command.

root@linuxhelp:~#  ln -s /usr/share/adminer/latest.php /usr/share/adminer/adminer.php

Create new .conf file for adminer and add alias configuration. For that, you need to run the following command.

root@linuxhelp:~# echo " Alias /adminer.php /usr/share/adminer/adminer.php"  | sudo tee /etc/apache2/conf-available/adminer.conf
Alias /adminer.php /usr/share/adminer/adminer.php

Once it is done, make sure you enable the newly created .conf file by running the following command.

root@linuxhelp:~# a2enconf adminer.conf
Enabling conf adminer.
To activate the new configuration, you need to run:
  service apache2 reload

And once when it is done, you shall restart the Apache service.

root@linuxhelp:~# systemctl restart apache2

You can now proceed with the installation process via GUI. So, open your browser and give htttp://localhost/adminer.php as the URL. The installer of Adminer appears on your screen. Fill the database details and click Login

Once you log in, the home page of Adminer appears.

You can look at the tables and views.

With this, the installation of Adminer comes to an end.