18 articles MySQL

How to Install Linux, Nginx, MySQL, PHP (LEMP stack) On CentOS 7

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 CentOS 7. The only difference between LAMP and LEMP stack is the web server in which the stack runs. Since the server is already…

How to Install Linux, nginx, MySQL, PHP (LEMP) stack on CentOS 6

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 CentOS 6. The only difference between LAMP and LEMP stack is the web server in which the stack runs. Since the server is already…

How to Install LAMP (Linux, Apache, MySQL, PHP) on Fedora

Introduction   LAMP is the most common configuration used in web server and it stands for Linux, Apache, MySQL, and PHP. This tutorial describes how to install LAMP stack on Fedora. The Linux part of the stack is already done as the virtual private server is up and running Fedora. Here you will see the…

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

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 Debian 7. The only difference between LAMP and LEMP stack is the web server in which the stack runs. Since the server is already…

How to Install Linux, Apache, MySQL, PHP (LAMP) stack on Debian

Introduction   LAMP is the most common configuration used in web server and it stands for Linux, Apache, MySQL, and PHP. This tutorial describes how to install LAMP stack on Debian. The Linux part of the stack is already done as the virtual private server is up and running Debian. Here you will see the…

How to Install Linux, Apache, MySQL, PHP (LAMP) stack On CentOS 6

Introduction   LAMP is the most common configuration used in web server and it stands for Linux, Apache, MySQL, and PHP. This tutorial describes how to install LAMP stack on to CentOS system. The Linux part of the stack is already done as the virtual private server is up and running CentOS. Here you will…

How to Install Linux, Apache, MySQL, PHP (LAMP) Stack on Ubuntu

Introduction   LAMP is the most common configuration used in web server and it stands for Linux, Apache, MySQL, and PHP. This tutorial describes how to install LAMP stack on to Ubuntu system. The Linux part of the stack is already done as the virtual private server is up and running Ubuntu. Here you will…

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…