Search For: lemp

Rocky Linux

How to Install WordPress with LEMP (Nginx, MariaDB, and PHP) on Rocky Linux 8 ?

This article covers how to install the LEMP stack on Rocky Linux 8. In fact, The terminology LEMP is an acronym for Linux, Nginx (pronounced as Engine X, hence the E) which is a web browser, MariaDB or MySQL – database, and PHP for processing dynamic content). LEMP stack is popularly used for hosting high-traffic and highly scalable web applications and websites.

Ubuntu

Install Moodle on Ubuntu 20.04 LTS - Step by step process ?

This article covers the best method to install Moodle Learning Management System on Ubuntu 20.04 LTS Focal Fossa. In fact, Moodle is a popular, free, and open-source Learning Management System (LMS). With Moodle, you can create a fully-featured website for education and training courses, suitable for fully online, hybrid, and in-person classroom experiences.

For additional help or useful information, we recommend you to check the official Moodle website.

Ubuntu

Install phpMyAdmin with Nginx on Ubuntu 18.04 - Step by Step Process ?

This article covers how to Install phpMyAdmin with Nginx on Ubuntu 18.04 system. When developing a website or web application, many users need the functionality of a database system like MySQL. However, interacting with the system solely from the MySQL command-line client requires familiarity with Structured Query Language — more commonly referred to as SQL — which can present a major hurdle for some users. phpMyAdmin was created to allow users to interact with MySQL through an intuitive web interface, running alongside a PHP development environment.

How to Secure phpMyAdmin with Let's Encrypt SSL ?

Before starting, you will need to install the Certbot client to download and install Let's Encrypt SSL.

1. First, add the Certbot repository with the following command:

$ add-apt-repository ppa:ahasenack/certbot-tlssni01-1875471

2. Next, update the repository and install the Certbot client using the following command:

$ apt-get update -y
$ apt-get install certbot python3-certbot-nginx -y

3. Once the Certbot has been installed, run the following command to download and install the Let's Encrypt SSL for your domain:

$ certbot --nginx -d phpmyadmin.domain.com

Debian

Install MySQL on Debian 9 Stretch - Step by Step Process ?

This article covers how to install mysql 8.0 and Secure MySQL on Debian 9 server. MySQL, the world's most popular open-source relational database management system is not available in the default Debian's repositories. MariaDB is the default database system in Debian 10.

The MySQL APT repository provides a simple and convenient way to install and update MySQL products with the latest software packages using Apt. The MySQL APT repository provides MySQL packages for the following Linux distros: Debian.

How to Uninstall MySQL from Debian?

To remove MySQL, Run the following commands:

$ sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
$ sudo apt-get autoremove -y
$ sudo apt-get autoclean
rm -rf /etc/mysql
sudo find / -iname 'mysql*' -exec rm -rf {} \;

How to secure MySQL ?

MySQL comes with a command we can use to perform a few security-related updates on our new install. Let's run it now:

$ mysql_secure_installation

This will ask you for the MySQL root password that you set during installation. Type it in and press ENTER. Then answer a series of yes or no prompts.

CentOS

Install MariaDB on CentOS 7 Server - Step by Step Process ?

This article covers how to install and Secure MariaDB on a CentOS 7 server. MariaDB is a fork of MySQL managed by the original MySQL developers. It's designed as a replacement for MySQL, uses some commands that reference mysql, and is the default package on CentOS 7.

To Install MariaDB 5.5 on CentOS 7:

1. Install the MariaDB package using the yum package manager:

$ sudo yum install mariadb-server

2. Once the installation is complete, start the MariaDB service and enable it to start on boot using the following commands:

$ sudo systemctl start mariadb 
$ sudo systemctl enable mariadb

To install MariaDB on CentOS 8:

1. Open the terminal application. Another option is to log in using the ssh command:

 ssh user@centos-8-server-ip

2. Install the MariaDB on CentOS 8 by running the command:

$ sudo yum install mariadb-server

3. Secure the MariaDB server in CentOS 8 by running the command:

$ sudo mysql_secure_installation

4. Finally test MariaDB installation by running the command:

$ mysql -u root -p

MariaDB vs MySQL:

Even though MariaDB is a fork of MySQL, these two database management systems are still quite different:

MariaDB is fully GPL licensed while MySQL takes a dual-license approach.

MariaDB supports a lot of different storage engines.

In many scenarios, MariaDB offers improved performance.

CentOS

Install LEMP Stack on CentOS 7 - Step by Step Process ?

This article covers how to install LEMP stack on CentOS 7. LEMP stands for the Linux operating system, with the ENginx web server (which replaces the Apache component of a LAMP stack). The site data is stored in a MySQL-based database, and dynamic content is processed by PHP.

A LEMP software stack is basically a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps.

To install Nginx on CentOS:

1. Add the CentOS 7 EPEL repository, run the following command:

$ sudo yum install epel-release

2. Now that the EPEL repository is installed on your server, install Nginx using the following yum command:

$ sudo yum install nginx

3. Once the installation is finished, start the Nginx service with:

$ sudo systemctl start nginx

CentOS

Install phpMyAdmin with Nginx on CentOS 7 - Step by Step Process ?

This article covers how to install phpMyAdmin with Nginx on CentOS 7 system. phpMyAdmin helps to handle the database administration of MySQL, MariaDB and Drizzle servers over the web. It basically provides the intuitive web interface and supports most of the MySQL features to create and drop databases, create/drop/alter tables, delete/edit/add columns, execute any SQL statement and to manage indexes on columns.

To install phpMyAdmin, run the following commands:

# yum install epel-release
# yum install phpmyadmin

To restart nginx, mariadb and php-fpm services, run the following commands:

# systemctl restart mariadb.service
# systemctl restart nginx.service
# systemctl restart php-fpm.service

CentOS

Install MySQL on CentOS 7 Server - Step by Step Process ?

This article covers how to install and secure a MySQL server on a CentOS 7 server. MySQL is one of the most widely used database management systems for websites and server applications.

To start the MySQL server daemon with the following command:

$ sudo systemctl start mysqld

systemctl doesn't display the outcome of all service management commands, so to be sure we succeeded, we'll use the following command:

$ sudo systemctl status mysqld

To configure MySQL, run the following command:

$ sudo mysql_secure_installation

To Current MySQL Version, run the command:

$ mysql -u root -p

Terms used in Managing MySQL User Permissions:

SELECT – users can read through the database using the select command.
CREATE – they can generate new tables.
DROP – allows users to remove tables.
DELETE – users can take out rows from tables.
INSERT – lets users add in rows into tables.
UPDATE – enable them to update the rows.
GRANT OPTION – they can grant or remove the privileges of other users.

Server Management Service

Install LEMP Stack on Debian 9 - Step by Step Process ?

This article covers steps to install a LEMP stack on a Debian 10 server using MariaDB as the database management system. The LEMP software stack is a group of software that can be used to serve dynamic web pages and web applications. The name "LEMP" is an acronym that describes a Linux operating system, with an (E)Nginx web server. The backend data is stored in a MariaDB database and the dynamic processing is handled by PHP.

Although this software stack typically includes MySQL as the database management system, some Linux distributions — including Debian — use MariaDB as a drop-in replacement for MySQL.

To install Nginx Web Server.

1. Run the apt commands:

$ sudo apt update
$ sudo apt install nginx

On Debian 10, Nginx is configured to start running upon installation.

Server Management Service

Install LEMP Stack on Ubuntu 18.04 - Step by Step Process ?

This article covers how to Install a LEMP Stack on Ubuntu 20.04 LTS. LEMP stack is a group of open-source software that is typically installed together to enable a server to host dynamic websites and web apps. LEMP stands for Linux OS, with the Nginx (pronounced like "Engine-X") web server, Data store in a MySQL database, and dynamic content is processed by PHP.

To install Nginx Web Server:

1. Run the commands below to install Nginx.

$ sudo apt update
$ sudo apt install nginx

2. Allow traffic on port 80.

$ sudo ufw allow 'Nginx HTTP'

You can verify the change by running:

$ sudo ufw status

Server Management Service

Install MySQL on Ubuntu 18.04 - Step by Step Process ?

This article covers how to install MySQL version 8.0 on an Ubuntu 20.04 server. By completing it, you will have a working relational database that you can use to build your next website or application.

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implements the relational model and uses Structured Query Language (better known as SQL) to manage its data.

To install MySQL using the APT package repository:

1. Update the package index on your server if you've not done so recently: