How to install Adminer on CentOS
How to install Adminer on CentOS
Adminer is a database management tool written in PHP similar to phpmyadmin which can support databases like MySQL, PostgreSQL, MS SQL and Oracle. This tutorial covers the installation process of Adminer on CentOS.
Installation procedure
Adminer needs LAMP server to run, so before installing Adminer first setup LAMP environment on the target server and then follow the below installation process. Download the package for adminer using the wget command.
[root@linuxhelp ~]# wget https://github.com/vrana/adminer/releases/download/v4.3.1/adminer-4.3.1.zip
--2017-04-18 15:24:09-- https://github.com/vrana/adminer/releases/download/v4.3.1/adminer-4.3.1.zip
Resolving github.com (github.com)... 192.30.253.112, 192.30.253.113
Connecting to github.com (github.com)|192.30.253.112|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://github-cloud.s3.amazonaws.com/releases/627735/aabca140-20f8-11e7-9459-8e927e40ec0f.zip?X-Amz-Algorithm=AWS4-HMAC-SHA256& X-Amz-Credential=AKIAISTNZFOVBIJMK3TQ%2F20170418%2Fus-east-
.
.
.
HTTP request sent, awaiting response... 200 OK
Length: 664410 (649K) [application/octet-stream]
Saving to: ‘ adminer-4.3.1.zip’
100%[===========================================================================================================================================> ] 664,410 37.6KB/s in 24s
2017-04-18 15:24:35 (27.3 KB/s) - ‘ adminer-4.3.1.zip’ saved [664410/664410]
Next extract the package directly into document root of apache webserver by executing the following command.
[root@linuxhelp ~]# unzip adminer-4.3.1.zip -d /var/www/html/
Archive: adminer-4.3.1.zip
7af1ee3702420620641d075ebfd54d4b1d220409
creating: /var/www/html/adminer-4.3.1/
inflating: /var/www/html/adminer-4.3.1/.travis.yml
creating: /var/www/html/adminer-4.3.1/adminer/
inflating: /var/www/html/adminer-4.3.1/adminer/call.inc.php
inflating: /var/www/html/adminer-4.3.1/adminer/create.inc.php
inflating: /var/www/html/adminer-4.3.1/adminer/database.inc.php
inflating: /var/www/html/adminer-4.3.1/adminer/db.inc.php
inflating: /var/www/html/adminer-4.3.1/adminer/download.inc.php
.
.
.
4.3.1/externals/jush/modules/jush-php.js
inflating: /var/www/html/adminer-4.3.1/externals/jush/modules/jush-simpledb.js
inflating: /var/www/html/adminer-4.3.1/externals/jush/modules/jush-sqlite.js
inflating: /var/www/html/adminer-4.3.1/externals/jush/modules/jush-sql.js
inflating: /var/www/html/adminer-4.3.1/externals/jush/modules/jush-textarea.js
inflating: /var/www/html/adminer-4.3.1/externals/jush/modules/jush-txt.js
Now rename the extracted directory by running the following command.
[root@linuxhelp ~]# mv /var/www/html/adminer-4.3.1/ /var/www/html/adminer
After extracting and renaming the directory, set the proper ownership and permission for the respective directory of adminer.
[root@linuxhelp ~]# chown -R apache:apache /var/www/html/adminer/
[root@linuxhelp ~]# chmod -R 775 /var/www/html/adminer/
Now login to MySQL database to create database and database user for adminer.
[root@linuxhelp ~]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with or g. Your MariaDB connection id is 10 Server version: 5.5.52-MariaDB MariaDB Server Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type ' help ' or ' h' for help. Type ' c' to clear the current input statement. MariaDB [(none)]> create database adminer Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> CREATE USER ' adminer' @' localhost' IDENTIFIED BY ' 123' Query OK, 0 rows affected (0.04 sec) MariaDB [(none)]> GRANT ALL ON adminer.* TO ' adminer' @' localhost' Query OK, 0 rows affected (0.02 sec) MariaDB [(none)]> flush privileges Query OK, 0 rows affected (0.01 sec) MariaDB [(none)]> exit Bye
Open the browser and navigate to following URL http://192.168.7.160/adminer/adminer and press enter. The adminer login page will appear.
The newly created database appears in the Adminer. Now the user can view and work with the database and their associated tables.
Wasn' t that an easy installation procedure? Adminer includes features like SQL syntax highlighting, user friendly interface and editing of other database objects.
Comments ( 0 )
No comments available