How To Install Adminer Tool in Linux

To Install Adminer Tool in Linux

Adminer is an user friendly database management tool written in PHP. It can manage content in MySQL, PostgreSQL, SQLite, Oracle databases effectively. Installation of Adminer tool is discussed in this article.

Features

• Basic functions are add/modify/remove databases.
• Display permissions and users.
• Databases can be exported and imported .
• List data in tables .
• Export views, database, data,routines, structure to CSV or SQL
• Modifies database objects.
• Executes SQL commands from a file.
• Light-weight.
• It shows process and also kill them.
• It supports multiple languages.
• Searching through multiple columns.

Requirement

• Supports PHP 5 with enabled sessions.
• Apache web server.
• Database

Uses of Adminer

• Performance is high
• Less size
• Exceptional support for MySQL
• Highly secured
• User friendly interface

To Install Adminer

Use the below link to download Adminer tool,
http://ftp.cn.debian.org/debian/pool/main/a/adminer/
Before installing Adminer, update the system.

root@linuxhelp:~# apt-get update
Ign http://ftp.de.debian.org jessie InRelease
Hit http://ftp.de.debian.org jessie Release.gpg                            
Hit http://ftp.de.debian.org jessie Release                                
Ign http://ftp.tw.debian.org jessie InRelease                                   
Hit http://ftp.tw.debian.org jessie Release.gpg                                 
Hit http://ftp.de.debian.org jessie/main amd64 Packages   
Hit http://ftp.tw.debian.org jessie Release                                          
Hit http://ftp.de.debian.org jessie/main Translation-en                              
Ign http://httpredir.debian.org jessie InRelease                                     
Hit http://ftp.tw.debian.org jessie/main amd64 Packages
Hit http://ftp.tw.debian.org jessie/main Translation-en
Hit http://httpredir.debian.org jessie Release.gpg
Hit http://httpredir.debian.org jessie Release                             
Hit http://httpredir.debian.org jessie/main amd64 Packages                 
Hit http://httpredir.debian.org jessie/main Translation-en
Reading package lists... Done    

Run the following command to Install Adminer.

root@linuxhelp:~# apt-get install adminer
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following NEW packages will be installed:
  adminer
0 upgraded, 1 newly installed, 0 to remove and 106 not upgraded.
Need to get 0 B/306 kB of archives.
After this operation, 1,190 kB of additional disk space will be used.
Selecting previously unselected package adminer.
(Reading database ... 159612 files and directories currently installed.)
Preparing to unpack .../adminer_3.3.3-1_all.deb ...
Unpacking adminer (3.3.3-1) ...
Setting up adminer (3.3.3-1) ...

Now Adminer tool is sucessfully installed.
Navigate to the http://localhost/adminer or http://< ip-address> /adminer

Enter the username and password to login into the Adminer.



Adminer home page appears as shown below.

To Create User

Go to privileges section and click create user. Enter the user credentials and click save.

To Create Database

Click create new database in the home page. Enter a name for the database and click save to create a new database.