Are you trying to install MariaDB on Ubuntu? Here’s how we do it.

Here at Bobcares, we have seen several such Ubuntu related queries as part of our Server Management Services for web hosts and online service providers.

Today, we’ll take a look at how to install MariaDB.

Know more about MariaDB

MariaDB is a database management system which is popularly used as a replacement for MySQL.

It has better features and better performance than MySQL. Moreover, it has new storage engines.

It is a free and open source software under the General Public License version 2. Also, it is maintained and developed by the MariaDB Foundation.

How we Install MariaDB 10.5 on Ubuntu 20.04 LTS

Now let’s take a look at how our Support Engineers install the MariaDB.

Generally, there are two different ways to install MariaDB on Ubuntu server.

1. Installing MariaDB from the Ubuntu repositories

2. Installing the latest version of MariaDB from the official MariaDB repositories.

1. Installing MariaDB from the Ubuntu repositories

• First, update the package index using the below command.
  $ sudo apt update
• Next, install MariaDB by running the below command.
  $ sudo apt install mariadb-server
• Finally, verify the installation. Usually, MariaDB will start automatically. However, you can run the below command to verify it.
  $ sudo systemctl status mariadb
• In addition, you can check the MariaDB version by running the below command.
  mysql -V

2. Install the latest version of MariaDB from the official MariaDB repositories

In order to install MariaDB from the MariaDB repositories, first, you need to add MariaDB repository on to the system. After that, the installation can be done from the APT repository.

• First, update the system. Also, make sure to install software-properties-common package.
  $ sudo apt update && sudo apt upgrade
$ sudo apt -y install software-properties-common
• Next, import MariaDB gpg key. For that, we run the below command to add Repository Key to the system.
  $ sudo apt-key adv –fetch-keys ‘https://mariadb.org/mariadb_release_signing_key.asc’
• Then we add the MariaDB APT repository.
  $ sudo add-apt-repository ‘deb [arch=amd64] http://mariadb.mirror.globo.tech/repo/10.5/ubuntu focal main’
• Finally, install MariaDB Server on 20.04 Linux
  $ sudo apt update
$ sudo apt install mariadb-server mariadb-client
Now, you will be asked for a confirmation to install MariaDB. For that, type y and hit Enter.

Securing MariaDB

In order to improve the security of the MariaDB installation, we run the below command.

$ sudo mysql_secure_installation

As a result, this script will ask you to change the root password. So make sure to enter a strong password. Also, remove the anonymous user, restrict root user access to the local machine and remove the test database.

[Need any further assistance with Ubuntu queries? – We are here to help you.]

Conclusion

In short, we can install MariaDB in two different ways. Today, we saw how our Support Engineers install MariaDB from the Ubuntu repositories and from the official MariaDB repositories.