For those of you who didn’t know, Adminer is a database management tool written in PHP. It is similar to phpMyAdmin and it is developed to improve security, user experience, performance etc. It is very lightweight and at the same time it is very powerful. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.
This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple. I will show you through the step by step installation Adminer on CentOS 6.
Step 1. First of all make sure that all packages are up to date.
yum -y update
Step 2. Install LAMP server and include some PHP extension.
yum install mysql mysql-server httpd php-common php-xml php-gd unzip
Start service Apache web server and MySQL also enable it to start on boot of the server:
service httpd start
service mysql start
chkconfig httpd on
chkconfig mysqld on
Step 3. Install Adminer.
Download the latest stable version of Adminer, At the moment of writing this article it is version 4.2.1:
cp -R adminer-4.2.1 /var/www/html/
Step 4. Accessing Adminer.
Adminer will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/adminer-4.2.1/adminer or http://server-ip/adminer-4.2.1/adminer and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.
Congratulation’s! You have successfully installed Adminer. Thanks for using this tutorial for installing Adminer on CentOS 6 system. For additional help or useful information, we recommend you to check the official Adminer web site.