How to install MariaDB 11 on Debian 9

Introduction

In this article, you will learn how to install MariaDB 11 on Debian 9.

This is to install MariaDB 11 on Debian 9. MariaDB is a database management system that is a fork of MySQL. It is extremely similar to MySQL, which is a database management system. Several different applications, including data warehousing, e-commerce, enterprise-level features, and logging programmes, all make use of the MariaDB database.

MariaDB will let you to fulfil all of your burden in an effective manner; it can function in any cloud database and can function at any scale, whether it be little or huge.

A database is a repository for information that can be easily retrieved and applied in the context in which it is required. When compared to recording information on a piece of paper or in a Word document, storing all of your information in a database allows it to be organized into tables, making it simple to retrieve each individual entry in a manner that is both systematic and accurate.

Add MariaDB 11 APT repository

# apt update

# curl -LsS https://downloads.mariadb.com/MariaDB/mariadb\_repo\_setup | bash -s -- --mariadb-server-version=11.0

You need to update the system after adding the repo.

# apt update

Install MariaDB 11 on Debian 9

# apt install mariadb-server mariadb-client -y

You can use the command to check the version of MariaDB that is currently installed;

# mariadb -V

Now, using the following command, check the current status of mariadb.

# systemctl status mariadb

Run the mariadb-secure-installation script, which assists you in protecting your MariaDB database server

# mysql\_secure\_installation

Enter current password for root (enter for none): Press Enter

Switch to unix_socket authentication [Y/n] : Press y

Change the root password? [Y/n] : Press y

Remove anonymous users? [Y/n] : Press y

If you choose you wish to let root login remotely, then press the y key; otherwise, press the n key.

Remove test database and access to it? [Y/n] Press y

Reload privilege tables now? [Y/n] : Press y

A username and password combination should be required in order to access the MariaDB shell.

# mysql -u root -p

To exit, run the following command

# exit

Conclusion

Hopefully, now you have learned how to install MariaDB 11 on Debian 9.

Also Read: How to Use Iperf to Test Network Performance

Thank You 🙂