How to Import and Export Databases and Reset a Root Password in MySQL

Import and Export of Databases   Let’s consider the export of database first. Make sure you have not logged into the MySQL shell. Open up your terminal and type in the following: mysqldump -u [username] -p [database name] > [database name].sql The database specified in the command will be exported to your droplet.   Similarly,…

How to Install PhpMyAdmin on a LEMP Server

Introduction   PhpMyAdmin is a free php tool for handling the administration of MySQL over web. PhpMyAdmin offers a wide range of operations with an intuitive web interface. Before starting to install phpMyAdmin, make sure that you already have LEMP stack installed on your VPS. In case if you don’t, refer this tutorial to get…

How to Install LLMP Stack on CentOS 6

Lighttpd is an open source web server designed for high performance environments. Several web 2.0 sites have been powered by lighttpd. LLMP stack refers to Linux, Lighttpd, MySQL and PHP. This tutorial will cover the basics of installing LLMP stack on CentOS 6.   System Prerequisites   This tutorial will use CentOS 6. You should…

How to Install Bolt on a VPS Running Ubuntu 12.04

Introduction   Bolt is an open source content management system built in PHP. Simplicity in configuration and usage makes it popular among content editors, back-end developer and front-end designers. This tutorial will cover the installation of Bolt on a VPS running Ubuntu 12.04.   System Prerequisites   VPS running Ubuntu 12.04 Apache or Nginx web…

How to Install the LLMP stack on Ubuntu 12.04

LLMP stack refers to Linux, Lighttpd, MySQL and PHP. This tutorial will cover the basics of installing LLMP stack on your server.  Lighttpd is an open source web server designed for high performance environments. Several web 2.0 sites have been powered by lighttpd.   Pre-Requisites   Here, I will be exploring the topic with an…

How to Install MySQL 5.6 from Official Yum Repositories

Introduction The development team of MySQL officially rolled out support for yum repositoriesin October 2013. Thismeans that now it’s possible to install the latest MySQL version directly from the source! This tutorial will deploy MySQL 5.6 on a fresh Centos 6 deployment. There are a number of features of MySQL. Selecting a Server As per…

How to Install LEMP stack on Ubuntu 12.04

Introduction LEMP is an open source software configuration used in web server and it stands for Linux, Nginx, MySQL, and PHP. This tutorial describes how to install LEMP stack on Ubuntu 12.04. The only difference between LAMP and LEMP stack is the web server in which the stack runs. Before we get down to the…

How to Install LEMP Stack on Arch Linux

Introduction LEMP is an open source software configuration used in web server and it stands for Linux, Nginx, MySQL, and PHP. This tutorial describes how to install LEMP stack on to your Arch Linux system. The only difference between LAMP and LEMP stack is the web server in which the stack runs. Before we get…

How To Install Concrete5 on Your VPS Running Ubuntu 12.04

About Concrete5 An open source Content Management System (CMS), Concrete5  is developed in PHP.  It is a very easy to understand and learn software that has been created with a concept that it should not only aid non-developer site owners  in creation and installation of websites, but should also help in operating and managing them…

Installation of Magento on a VPS operating Ubuntu 12.04

About Magento Magento software, owned by eBay.inc, is a widely used, open source e-commerce web application created in PHP (5.2.13+). It was made using Zend Framework’s components and a big community contributes towards its development. It can be operated by utilizing Apache web server and it uses MySQL as a storage engine. This guide shows…