How to install and configure NGINX as reverse proxy

NGINX is a web server with excellent performance and low memory footprint. NGINX can be used as a reverse HTTP proxy, as a generic TCP / UPD proxy, as a mail proxy server and as a load balancer, today we will install NGINX on Debian GNU/Linux and use it as a generic TPC/UPD proxy.

How to install MariaDB on Alpine Linux

Alpine Linux is a minimalist distribution with a focus on security and simplicity.

MariaDB is one of the most popular database servers in the world, created by the original MySQL developers and initially conceived as a direct and improved MYSQL replacement. MariaDB is fast, scalable, and robust, with a rich ecosystem of storage engines, plugins, and other tools that make it versatile and flexible in different scenarios. MariaDB is developed as free software under the GPL license. The latest versions of MariaDB also include GIS and JSON functions.

How to install MySQL 8.0 in Debian

MySQL

MySQL is a fast, efficient, secure, stable, easy-to-use, multi-platform, multi-threaded, multi-user, and well-documented relational database manager/server. Currently Oracle guides the development of MySQL, however the community version is available under the GPL license so it is still free software.

MySQL 8.0:

  • Add a new caching_sha2_password authentication plugin is available. Like the sha256_password plugin, caching_sha2_password implements SHA-256 password hashing, but uses caching to address latency issues at connect time.
  • Supports roles, which are named collections of privileges. Roles can be created and dropped. Roles can have privileges granted to and revoked from them. Roles can be granted to and revoked from user accounts.
  • Incorporates the concept of user account categories, with system and regular users distinguished according to whether they have the SYSTEM_USER privilege
  • Maintains information about password history, enabling restrictions on reuse of previous passwords also it is possible to configure user accounts such that too many consecutive login failures due to incorrect passwords cause temporary account locking.
  • Add the new authentication mechanism: caching_sha2_password that implements the SHA-256 encryption algorithm (like the sha256_password mechanism) but using a cache to solve latency problems during the connection process.
  • Incorporates several improvements to the InnoDB engine and the JSON data type.

File Browser, a web file manager

File Browser is an elegant file browser and file manager for the web with the following features:

  • Clear and simple interface
  • Allows these operations over the files:
    • Upload
    • Download
    • Delete
    • Edit
    • Preview
  • User administration
    • You can create multiple users and each user have their own directory
  • Easy to install

MySQL 8.0, change root password

MySQL

When you install MySQL 8.0 in Ubuntu 20.04 the root has enabled the auth_socket plugin by default

Unattended Debian installation

Debian GNU/Linux

Debian is a rock solid GNU/Linux distribution with more than 30,000 packages available in its official repositories. Debian is suitable for servers, workstations, mobile devices and embedded systems.

Debian has a simple and clean installation system which allows installing Debian with little effort as long as the number of installations to be executed is minimal, but as this number grows the installation procedure becomes cumbersome and tedious (Please note that during the installation process it is necessary to answer configuration questions and package selection), for example if we want to install Debian in a lab that has 15 workstations, we need to repeat this process 15 times, which is possible , but if we want to deploy Debian in mass, for example 100, 200, 500 or 1000 installations, it is no longer feasible, this is the reason why the Debian developers have created a system that allows automatic or unattended installations starting from a configuration file (preseed).

How to indent a source code block in VIM?

VIM

VIM is a powerful editor with a rich ecosystem and many many features it's used by many users around the world in their daily administrations and development tasks.

This tip is very useful if you want to use VIM (mainly) as your source code editor.

3 ways to install Node.js

Node.js is an event-driven and asynchronous Javascript runtime environment designed to build network applications and to run server-side Javascript applications allowing you to build applications using a single programming language.

npm is a package and dependency manager for Node.js

Today we will learn how to install Node.js and npm on Debian, Ubuntu, CentOS and on any GNU/Linux distro.

How to Compile PHP 8.0 in Debian 10?

On November 26, 2020, the PHP development team released PHP 8.0, PHP 8.0 comes with numerous improvements and new features such as:

  • Union Types
  • Named arguments
  • Match expressions
  • Attributes
  • Constructor Property Promotion
  • Nullsafe Operator
  • Weak Maps
  • Just In Time Compilation
  • and more

How to install Apache on Ubuntu 20.04?

The Apache HTTP Server Project is a community effort to develop and maintain a "free software" HTTP server for modern operating systems (UNIX, GNU / Linux, BSD, Windows).