How to Install Adminer in CentOS?

Posted on April 19th, 2018

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


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.


3 Responses to “How to Install Adminer in CentOS?”

  1. louis martin says:


    je peux accéder a adminer via l’interface WEB mais j’ai un access denied avec une erreur type

    Host ‘TESTSQL.’ is not allowed to connect to this MySQL server

  2. jerome p says:

    De mon côté, je suits bien les instructions mais quand je veux redémarrer apache j’ai le message d’erreur

    httpd: Syntax error on line 353 of /etc/httpd/conf/httpd.conf: Syntax error on line 3 of /etc/httpd/conf.d/adminer.conf: /etc/httpd/conf.d/adminer.conf:3: was not closed.

Leave a Reply