×

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


Install MariaDB on CentOS 8 - Step by step process ?

This article will guide you on how to install MariaDB on your CentOS 8 system. Now you can create new databases and grant privileges to other database users. Also, you can add users and create new databases for web or desktop applications which will be written in PHP, Python, and so on.

In MariaDB replication is faster whereas in MySQL replication is slower. 

MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition. 

MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.


To uninstall MariaDB and install mysql:

1. Purge mariadb sudo apt purge mariadb-* Remove all databases ('Yes' answer)

2. Purge mysql sudo apt purge mysql-*

3. Remove folders: sudo rm -r /usr/share/mysql/ sudo rm -r /etc/mysql/ sudo rm -r /lib/systemd/system/mysql.service.

4. Now you can try to install oracle mysql: sudo apt install mysql-server.


MariaDB on Debian 10 - Step by step process to install it ?

This article will guide you on the different methods to conveniently install and start the MariaDB service on a Debian 10 system. Also, we dealt with how to easily remove MariaDB from your Debian 10 system. 

In MariaDB replication is faster whereas in MySQL replication is slower. 

MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition. 

MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.

Since MariaDB is a fork of MySQL, the database structure and indexes of MariaDB are the same as #MySQL. 

This allows you to switch from MySQL to MariaDB without having to alter your applications since the data and data structures will not need to change. Data and table definition files are compatible.


To install #MariaDB on #Debian , follow these steps:

1. First update the apt packages index by typing: sudo apt update.

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

3. The MariaDB service will start automatically.