InfoWorld how-to's

How-to: Get started with MariaDB

An easy step-by-step guide to setting up a MariaDB database server and phpMyAdmin on Fedora, CentOS, or Ubuntu

ready set go checkered flag sports race rally car racing 000003607936

MariaDB is a fork of the wildly popular open source database MySQL. Although MariaDB is very similar to MySQL, it is not necessarily the same. One of the primary goals behind the MariaDB project is to serve as a drop-in replacement for MySQL, but MariaDB also offers features beyond those available in MySQL.

For example, MariaDB 5.5 is intended to be a replacement for MySQL 5.5. However, MariaDB 10 is a departure from the version 5.x tree and represents a new direction for MariaDB. If you are replacing MySQL, you're probably better off using a 5.x version. Otherwise, start fresh with version 10.x.

To those uninitiated in how databases work, setting up MariaDB for the first time can be somewhat daunting. Nevertheless, with a few pointers, you can quickly get a new MariaDB instance up and running, ready to work with your application.

For the purposes of this guide, we’ll assume that the reader has little or no experience with MariaDB or MySQL on Linux, and we’ll concentrate on getting MariaDB installed and configured to the point where an application can be connected to the database and begin operation. More advanced elements of MariaDB, such as database programming and use of the SQL language itself, are beyond the scope of this article.

Installing MariaDB

To continue reading this article register now

How to choose a low-code development platform