As already shown in the title of this article, “Install Adminer on CentOS 7 via command line”, it is obviously can be concluded that the subject which is going to be discussed in this article is definitely on how to install adminer on CentOS 7 via command line. Basically, it can be done in any operating system which has the same flavor or it has the same type of environment with CentOS 7. But first of all, what is Adminer actually ?. To know Adminer in detail, just visit the following link.
As the tagline presented in its official home page, the Adminer’s official home page in this link, it claims as a utility which performs its function as a database management by only using one file. Compared it with another utility which has the same functionality such as PHPMyadmin, Adminer is really just need one single file stored to be able to perform as a database management utility.
To be able to install or to activate Adminer, just download one single file which is then stored or saved in a place where it can be processed or rendered by any running Webserver such as Apache Webserver. Below are the steps explained in the order sequence :
1. Just go to the download link presented in the Adminer’s official home page in this link. It can be shown in the following image :
Choose the correct one to be downloaded and in this context just select and click the one which is the most suitable for the need. Is it the Adminer or specifically Adminer for MySQL as shown in the following image :
2. Store the file in the location which can be processed by any running Webserver. In this context of the article the file itself being processed by Apache Webserver, so just put it in the document root folder where by default it will be processed. Don’t forget to define it in a configuration file to inform Apache Webserver the location of the Adminer file so it can be processed. For an example, if the file itself has already been downloaded to the root home folder, in this context /root.
[root@localhost ~]# mkdir /usr/share/adminer && cp adminer-4.2.1.php /usr/share/adminer/index.php && cd /usr/share/adminer [root@localhost adminer]# ls -al total 328 drwxr-xr-x. 2 apache apache 23 Agu 23 02:36 . drwxr-xr-x. 79 root root 4096 Agu 23 02:36 .. -rw-r--r--. 1 apache apache 330757 Agu 23 02:36 index.php [root@dakfisik adminer]#
The above command is a combined command execution separated by ‘&&’ signs. It create a directory named ‘adminer’ located in ‘/usr/share’ and then copy the already downloaded file named ‘adminer-4.2.1.php into the already created folder and basically changed the name into index.php. As it already known that one of the default executed file which Apache Webserver is looking for is ‘index.php’.
3. Create the proper configuration for accessing Adminer index.php file. It can be created in ‘/etc/httpd/conf.d’. The location itself are vary depend on the Webserver utilized and also the environment where the Webserver is installed. In this context of article, the file created will be named as ‘adminer.conf’ to make it easy to be recognized as the Adminer configuration file which is made to be processed by Apache Webserver. Below is the position of the file in the tree format :
root@hostname:/etc/httpd/conf.d# tree . . └── adminer.conf 0 directories, 1 files root@hostname:/etc/httpd/conf.d#
4. Edit the file and insert the following content :
Alias /myadminer "/usr/share/adminer" <Directory "/usr/share/adminer"> AllowOverride All Options FollowSymlinks Order deny,allow Deny from all Allow from all Require all granted </Directory>
5. Don’t forget to restart the service of Apache Webserver so that Apache Webserver will processed the already created Adminer configuration file. Access it with the URL address ‘http://your-server-ip-or-name-server/myadminer’.