Data Base

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.

How to install MySQL 8.0 in Ubuntu 20.04

MySQL

MySQL is a fast, efficient, secure, stable, easy-to-use, cross-platform (GNU / Linux, * BSD, Windows, …), multi-threaded, multi-user and well-documented relational database server. It is currently developed under the guidance of Oracle, however the community version is available under the GPL (a free software license).

MySQL 8.0 supports roles, which are named collections of privileges. Roles can be created and dropped also add the concept of user account categories and now maintains information about password history, enabling restrictions on reuse of previous passwords, for example a DB administrator can configure user accounts such that too many consecutive login failures due to incorrect passwords cause temporary account locking. Several improvements to the InnoDB engine and the JSON data type.

How to install PostgreSQL on CentOS


PostgreSQL (also called Postgres) is an advanced and powerful Object-Relational database management system (DBMS), with a strong reputation on enterprise environment, designed for scalability, performance, high availability, reliability and feature robustness. It supports a large part of the SQL standard and offers many modern features:

How to install MySQL 5.7 on CentOS 7

MySQL

MySQL is a relational database server with a great reputation for being fast, efficient, safe, stable, easy to use, multiplatform (GNU/Linux, * BSD, Windows,…) and well documented. The current MySQL development process is under Oracle's umbrella but the community version is released as free software and you can use under GPL terms.