How to Install Adminer in CentOS?

How to Install Adminer in CentOS?

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.