Chive is a free, open source, web-based database management tool, designed to bring joy to web developers with easy administration, super fast UI and state of the art web technologies. We already have featured a web-based database management tool called Adminer in our previous article. Chive is a yet another alternative for phpMyAdmin and Adminer database management tools. If you are searching an alternative for phpMyAdmin and Adminer, then Chive is worth to give a try. You can find the detailed comparison between phpMyAdmin and Chive here.
Install Chive
In order to install Chive, first you must install PHP with mysql support. If you’re using RHEL/CentOS based systems, follow the below link to install Apache, MySQL or MariaDB and PHP.
Install LAMP (Apache with MariaDB and PHP) on CentOS/RHEL/Scientific Linux 6
If you’re using Debian/Ubunutu systems, follow the below link.
Install LAMP Server (Apache, MySQL or MariaDB, PHP) On Ubuntu 13.10 Server
Download the latest Chive software from the official download page.
wget -O - http://www.chive-project.com/Download/Redirect|tar -xzp
The above command will download latest version of Chive project and extract it into a directory called Chive.
Copy the Chive folder to your apache root document folder.
On CentOS/RHEL Systems:
mv chive/ /var/www/html/chive
On Ubuntu/Debian Systems:
sudo mv chive/ /var/www/chive
Restart the apache service.
On RHEL/CentOS Systems:
service httpd restart
On Ubuntu/Debian Systems:
sudo service apache2 restart
Launch Chive
Now open up the browser and navigate to URL http://ip-address/chive or http://localhost/chive.
Enter the MySQL username and password.
This is how Chive main console looks:
That’s it. Now you can administer the MySQL/MariaDB databases using Chive tool.
