Author: RoseHosting

How to Install LEMP on Ubuntu 16.04

The following article describes how to install a LEMP stack on an Ubuntu 16.04 VPS. LEMP (Linux, Nginx, MySQL, PHP) should not be confused with the popular LAMP (Linux, Apache, MySQL, PHP) stack. This tutorial is for the LEMP (Nginx) stack and it’s commonly used on Ubuntu 16.04 servers. Update the server Make sure that all installed packages on your Ubuntu 16.04 VPS are up to date. apt-get update && apt-get upgrade You can also configure automatic updates. Install Nginx Before installing the Nginx web server, make sure that there is no other web server like Apache installed on the […]

How to Install LAMP on Ubuntu 16.04

LAMP (Linux, Apache, MySQL, PHP) is a combination of open source software, typically installed on a server used for hosting dynamic websites and web applications. It includes the Linux operating system, the Apache web server, MySQL for data storage and management and PHP for handling the dynamic content. In this tutorial, we will go through a complete LAMP installation on a Ubuntu 16.04 based VPS. Requirements SSH access with root privileges to your server, as well as an Ubuntu 16.04 VPS is required for you to be able to complete all the steps in this tutorial. 1. Update your system […]

Create a new MySQL user and Grant Permissions to MySQL Database

In this tutorial, we will explain how to create a new user and grant permissions to that user in MySQL. MySQL is an open source relational database managed system(RDBMS) that enables users and applications to store, organize, and retrieve their data. It has an access control system that consists of permissions that the users can have within tables and databases, we will take a look at some of the options this access control system offers later in this tutorial. Let’s start by logging in To log in to our MySQL system we use the following command: # mysql -u root […]

How to set up MySQL Cluster on Ubuntu

The MySQL NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (Network DataBase). In this tutorial, we will show you how to set up MySQL Cluster on an Ubuntu 16.04 VPS. We will use a total of 4 virtual servers, one for the management, one SQL node and two data nodes: – management VPS – SQL VPS – data1 VPS – data2 VPS Install and Configure MySQL Cluster on the Management VPS Download the latest version of MySQL Cluster available at to a directory of your virtual server and […]

TEL/電話+86 13764045638
QQ 47079569