Adminer

Let us Read for you.

Introduction

I came to know about a few years ago as I have studied that the server itself was not compromised the hacker gained access through PHP My Admin vulnerability. The Adminer is discovered by security and server protection.

Note: The Adminer is available for install from Ubuntu Repositories using

“sudo apt-get install adminer”

But,  to get the latest features we will install the latest version manually. This advanced Adminer works with the following databases:

MySQL

PostgreSQL

SQLite

MS SQL

Oracle

SimpleDB

Elastic search

Mongo DB

If you have any questions or comments, feel free to post them at the bottom I will be glad to help with any issues.
Step 1  Connect to your server as the admin user via SSH or open a command prompt.

ssh username@your.server.ip
Step 2 Install apache2 and MySQLyj-server unless you are installing it on an existing web server. It is needed to update and upgrade the server.
sudo apt-get update && sudo apt-get upgrade

Install Apache, PHP and MYSQL Server and some PHP extensions

sudo apt-get install apache2 php5 php5-curl php5-cli php5-mysql php5-gd mysql-client mysql-server

For the root user, enter the MySQL password.

Note: For security makes this one different than your server’s password, and try not to use this user in any application that requires a database to store and pull data from.

Step 3 Then, Download the Adminer on the root folder of Apache web server

sudo mkdir /usr/share/adminer

sudo wget “http://www.adminer.org/latest.php” -O /usr/share/adminer/latest.php

sudo ln -s /usr/share/adminer/latest.php /usr/share/adminer/adminer.php

echo “Alias /adminer.php /usr/share/adminer/adminer.php” | sudo tee /etc/apache2/conf-available/adminer.conf

sudo a2enconf adminer.conf

sudo service apache2 restart