Introduction LEMP is the acronym used to describe a specific open source software configuration for Linux web servers. L – Linux (In this case, Debian 8) E – Nginx (Pronounced Engine X) M – MySQL P – PHP This tutorial will walk you through how to install nginx, mysql and php-fpm, on your Debian 8 server.…
MySQL is one of the popular open source database management system software that will enable its users to store, organize and retrieve data easily. It has the ability to offer specific permissions for specific users within its tables and databases. In this article, you will be learn how to create a new user and grant permissions…
Import and Export of Databases Let’s consider the export of database first. You should not be logging to MySQL shell. First open up your terminal and type in the following: mysqldump -u [username] -p [database name] > [database name].sql This will export specified database to your droplet. Similarly, to import a database, you need to…
Introduction PhpMyAdmin is a free php tool for handling the MySQL over web. It 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 it done. Install…
About LAMP-Stack LAMP represents Linux, Apache, MySQL and PHP. It is an open source software group which is used for managing web servers. Installation The user must have root privileges on the server to install and the steps are given below: Step One – Installation of Apache & MySQL Almost half of the web servers running across…