5 articles MySQL

How to Install Linux, Nginx, MySQL, PHP (LEMP) Stack on Debian 8

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.…

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. 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…

Installation of Linux, Apache, MySQL, PHP (LAMP) on CentOS 6

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…