How to install MariaDB 10.4 on Ubuntu 18.04?

Windows Articles

How to check domain controller status in Windows Server 2019/2016.

Hello! The administration of Windows Server is very important. Indeed, the administrator manages many processes and roles that affect the optimal functioning...

How to install Vanilla Forum on Ubuntu 20.04?

Hello, folks. This post is about how to install Vanilla Forum on Ubuntu 20.04. Vanilla is an opensource discussion...

How to backup and restore Group Policy Objects in Windows Server 2016/2019.

Hi! Previously we have mentioned that Windows Server pursues a centralized administration of each role and service. In this way, a fluid...

How to use the ls command?

The ls commands list the content and optional information of the directories and files. When you execute the Ls command without options,...

How to Install APK file on Android

Hello Friends! Today we bring you a simple guide on how to install an APK file in Android. What...
angeloma
angeloma
Senior Writer and partner

Debian and Ubuntu are some of the most stable Linux distributions out there. This is because the packages that are part of the official repositories are frozen and tested many times by many people. However, this brings a consequence: that we will not be able to have the most recent versions of the programs. An example of this is MariaDB which is a vital program for many people. So, today I will show you how to install MariaDB 10.4 on Ubuntu 18.04.

MariaDB is a well-known archi Database Relationships Management System that is a MySQL fork. This is due to the purchase of Sun Mycrosystem by Oracle. It is perfectly compatible with MySQL and is available in most Linux distributions.

In Ubuntu 18.04 LTS the version of MariaDB that is available in the official repositories is 10.1, but recently has seen the release of version 10.4 with some interesting new features. Some of them are:

  • The unix_socket authentication plugin is now default on Unix-like systems. This represents a considerable improvement in authentication security.
  • The obsolete mysql.host table is no longer created
  • User password expiry. This forces you to change it periodically.
  • User accounts and global privileges are now stored in the mysql.global_priv table.

And many other news related to the creation of cLuster and Galera 4. If you want to know them, I recommend you to read the changes and improvements of version 10.4.

So, using this version on our Ubuntu 18.04 is a good idea.

Installing MariaDB 10.4 on Ubuntu 18.04

The first step is to install some necessary packages. So open a new terminal session and run the following command:

:~$ sudo apt-get install software-properties-common

The easiest way to install MariaDB on Ubuntu 18.04 is through the application repositories. To do this you have to add the GPG key of the repositories:

:~$ sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

1.- Adding the GPG key for the repository
1.- Adding the GPG key for the repository

At the end, we will be able to add the repository itself.

:~$ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.4/ubuntu bionic main'.

Next, the APT cache needs to be refreshed to recognize the new repository:

:~$ sudo apt update

Now, we can install MariaDB 10.4. To do this, use the following command:

:~$ sudo apt install mariadb-server

2.- Installing MariaDB 10.4 on Debian 10
2.- Installing MariaDB 10.4 on Debian 10

If you have it installed, just update the distribution:

:~$ sudo apt upgrade

With MariaDB installed, the first step is to define a root password and secure the installation:

:~$ sudo mysql_secure_installation

3.- Securing the MariaDB installation
3.- Securing the MariaDB installation

And finally check the installed version:

:~$ mysql --version

4.- MariaDB version
4.- MariaDB version

Now you can work with MariaDB. That is it.

Conclusion

MariaDB 10.4 is a good improvement over previous versions. But it is not always available in the official repositories of other Linux distributions. Today you have learned how to install it in Ubuntu 18.04.

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article

How to check domain controller status in Windows Server 2019/2016.

Hello! The administration of Windows Server is very important. Indeed, the administrator manages many processes and roles that affect the optimal functioning...

How to install Vanilla Forum on Ubuntu 20.04?

Hello, folks. This post is about how to install Vanilla Forum on Ubuntu 20.04. Vanilla is an opensource discussion...

How to backup and restore Group Policy Objects in Windows Server 2016/2019.

Hi! Previously we have mentioned that Windows Server pursues a centralized administration of each role and service. In this way, a fluid...

How to use the ls command?

The ls commands list the content and optional information of the directories and files. When you execute the Ls command without options,...

How to Install APK file on Android

Hello Friends! Today we bring you a simple guide on how to install an APK file in Android. What...
x