Adminer is a full-featured database management tool which is written in PHP. Conversely to phpMyAdmin, it consists of a single file ready to deploy to the target server. Adminer is an open source database management tool and it is much faster and secure than the traditional way of phpMyAdmin usage. It is very lightweight as well as very powerful. Moreover, with the help of Adminer, it is very easy to manage a lot of database engines like MySQL, Oracle, Postgre etc. Now let’s have a look at the installation procedure of Adminer.
1) SSH to the server as root.
# ssh root@IP
2) Create a directory adminer in /var/www/html/
# mkdir /var/www/html/adminer
3) Change the current directory to /var/www/html and download the latest version of adminer.
# cd /var/www/html
# wget https://www.adminer.org/static/download/4.2.5/adminer-4.2.5.tar.gz
4) Now untar the downloaded file.
# tar -xvf adminer-4.2.5.tar.gz
5) Change the owner and group of the adminer to apache.
# chown -R apache:apache adminer /var/www/html/adminer/
6) Assign the permission by executing the following command for adminer.
# chmod -R 775 /var/www/html/adminer/
7) Now create a database for adminer by using the below mentioned commands.
# mysql -u root -p
# create database adminer;
# CREATE USER ‘adminer’ @ ‘localhost’ IDENTIFIED BY ‘Password’;
8) Grant all privileges for the user adminer.
# GRANT ALL ON adminer * TO ‘adminer’@’localhost’;
# flush privileges;
9) Now configure the apache to use the adminer. For this create the following configuration file.
# vi /etc/httpd/conf.d/adminer.conf
10) Enter the below-mentioned entries in the created configuration file.
Alias /adminer “/usr/share/adminer”
<Directory “/usr/share/adminer”>
AllowOverride All
Options FollowSymlinks
Order deny,allow
Deny from all
Allow from IP
Replace the ‘IP’ with your local end IP address or allow for all users.
11) Restart Apache service
# /etc/init.d/httpd restart
12) Access the adminer via your favorite web browser by the URL: IP address/adminer
If you need any further help please do reach our support department.