Adminer is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, Adminer consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle. This post assumed that MySQL has been installed and configured as per documented guidelines below :
How to Install Httpd on CentOS 6.2
How to Install MySQL Database Server on CentOS 6.2
How to Secure MySQL Database Server
1. Download Adminer:
[root@centos62 ~]# wget http://cdnetworks-kr-2.dl.sourceforge.net/project/adminer/Adminer/Adminer%203.3.3/adminer-3.3.3.zip
2. Unzip the adminer’s zip file :
[root@centos62 ~]# unzip adminer-3.3.3.zip -bash: unzip: command not found
3. If unzip not installed, proceed to install it :
[root@centos62 ~]# yum install unzip -y Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: centos.maulvi.net * epel: mirror01.idc.hinet.net * extras: centos.maulvi.net * rpmforge: fr2.rpmfind.net * updates: centos.maulvi.net Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package unzip.i686 0:6.0-1.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ==================================================================================================== Package Arch Version Repository Size ==================================================================================================== Installing: unzip i686 6.0-1.el6 CentOS6.2-Repository 143 k Transaction Summary ==================================================================================================== Install 1 Package(s) Total download size: 143 k Installed size: 309 k Downloading Packages: Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : unzip-6.0-1.el6.i686 1/1 Installed: unzip.i686 0:6.0-1.el6 Complete!
4. Unzip the adminer file :
[root@centos62 ~]# unzip adminer-3.3.3.zip
5. Copy extracted adminer’s file into DocumentRoot of your web server :
[root@centos62 ~]# cp -R adminer-3.3.3 /var/www/html/adminer
6. Login from web browser as below :
http://192.168.1.44/adminer/adminer/
As always if you need any help you can reach us on twitter @ehowstuff or drop us a comment below.