How to install MariaDB on Raspberry Pi OS Most of the projects will work on MariaDB without requiring any changes. MariaDB has been created following the MySQL acquisition by Oracle in 2009. So, for now, there’s barely any difference. MariaDB is a fork of MySQL (= they created it from a copy of the MySQL source code).

You can find my top 5 recommendations here. MariaDB is not the only database management system available on Raspberry Pi. Big companies like Google, Mozilla and Wikipedia are using it. It’s not yet one of the most popular database engines ( 0.58% market share according to Datanyze), but it’s growing fast. It started in 2009 and is now supported by major companies like Google and Alibaba. It’s a free service, available on any Linux distribution. Similar to how Apache is used to host a web server, MariaDB is used to store data in databases.

MariaDB is the service that will host the database. The folder is the database, each Excel file is a table, and they contain one column for each data to store. I often explain a database as a folder on your computer, with many excel files in it. What is a database?īut if you are just starting on MySQL, imagine a database as file where you will store any data you need to keep.įor example, this website uses a database to store the content, comments, or website configuration of each post. Let’s start with a short explanation of what MariaDB is for those who may need this. The first third of the book teaches you the basics, but the following chapters include projects you can try on your own. It’s a 30-day challenge, where you learn one new thing every day until you become a Raspberry Pi expert. If you are looking to quickly progress on Raspberry Pi, you can check out my e-book here. In this tutorial, I will guide you through each step, so you’ll know exactly what to do. The configuration can then be found in the /etc/mysql folder.

MariaDB is available in the default Raspberry Pi OS repository, and can be installed with: “apt install mariadb-server” or via the package manager with the Desktop edition. That’s why I’m sharing a specific tutorial on how to install it on your Raspberry Pi. But I know that some of you have problems installing and configuring it properly. MariaDB is one of the most common services used on Raspberry Pi, it has now replaced MySQL on most distributions.

Install mariadb debian 10