In the previous article we explained how to install phpmyadmin on CentOS, but unfortunately, the application only manages MySQL or MariaDB. There is an application can manage MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB via browser is called Adminer. Adminer is an open source application written in PHP. It is built by Jakub Vrána who started to develop this tool as a light-weight alternative to phpMyAdmin, in July 2007. This article will explain how to install Adminer on CentOS 7 and as of this writing, version of Adminer is 4.6.1.
Before we download Adminer, install required packages:
And then we download it using these commands:
Then, go to browser and type:
And will be display like this:
If we have MariaDB on the server and want to access using Adminer, so choose MySQL system and type your username and password. If correct, you can access your database:
Make sure there is php-pdo_pgsql package installed on the server if we want to access PostgreSQL using Adminer. We can change designs of Adminer with replacing the adminer.css file in this link on Alternative designs section. If we want to limit someone to access adminer via browser only using IP 192.168.56.101, we must configure /etc/httpd/conf.d/adminer.conf file and add the script: