×

Install MariaDB on Ubuntu 20.04 LTS - Step by step process to do it ?

This article covers how to install MariaDB on Ubuntu 20.04 LTS system. Also you will learn how to secure it by configuring some security options and then, in the end, we have tested the connection to MariaDB. The #Ubuntu server should have a non-root administrative user and a firewall configured with UFW.

By following the above simple steps, you can easily setup MariaDB on your ubuntu system. 

For more information, visit MariaDB's official documentation .

MariaDB is one of the most widely used and open-source database management systems. 

MariaDB is considered as a replacement for #MySQL and has much more features and capabilities that you cannot find in MySQL.


To install #MariaDB on Debian:

1. Update your package index using apt;

$ sudo apt update

2. Install the mariadb-server package using apt. The package also pulls in related tools to interact with MariaDB;

$ sudo apt install mariadb-server

3. Run the included mysql_secure_installation security script to restrict access to the server;

$ sudo mysql_secure_installation


Step by step process to install MariaDB on Linux Mint 20 ?

This article will guide you on steps to install #MariaDB on the #Linux operating system. 

MariaDB offers more and better storage engines. NoSQL support, provided by Cassandra, allows you to run SQL and NoSQL in a single database system. MariaDB also supports TokuDB, which can handle big data for large organizations and corporate users.

As a columnar database, MariaDB ColumnStore stores table data in columns rather than rows. Data partitioning by columns is also called Vertical Partitioning.

MariaDB is a drop in place replacement for #MySQL, but you can also install it alongside MySQL. 

To install MariaDB on #Ubuntu 18.04, follow these steps:

1. Update packages index. sudo apt update.

2. Once the packages list is updated, install MariaDB by issuing the following command: sudo apt install mariadb-server.

3. The MariaDB service will start automatically.