Introduction of MariaDB

Introduction of MariaDB

Last Updated : 05 Aug, 2022

MariaDB is one of the most popular open-source relational database management system and could be used as a great replacement of MySQL. It is developed by original developers of MySQL. MariaDB can also stores data in various tables. It is also part of most cloud offerings and default in most Linux distributions. To establish the relationship between these tables, primary keys and foreign keys are used.

Features of MariaDB

It is fast, scalable and robust.
It has rich ecosystem of plugins, storage engines, etc which makes it very versatile for a wide variety of use cases.
It is licensed under GPL, LGPL, or BSD.
It uses a standard and popular querying language. It runs on different operating systems and supports variety of programming languages.
It also offers support for PHP and offers Galera cluster technology.

Installation of MariaDB

1. Download MariaDB. 2. Read their terms and conditions and accept them if you think it would be fine to do so. Then in the next step simply click next. 3. Set the root password and enable access from remote machine option. set-password-mariadb 4. Now set the port number and set engine buffer pool. It is recommended to keep them as default. setting-port-engine-mariadb 5. Then click on install. Mariadb would be installed in a minute after this. 6. In order to verify the installation, Go to your installation directory and bin folder in that(by default it is "C:\Program Files\MariaDB 10.5\bin").and open cmd through address bar and write the following command there.

mysqld.exe --console

veriffying-mariadb Note: Mariadb installs a client for its working named as heidi, so it could even be used to work with mariadb.

Introduction of MariaDB

khu5h1

Improve

Article Tags :

Similar Reads

How to Connect to MariaDB?

MariaDB is a free open-source relational database management system that may easily take MySQL's place. MariaDB may be used by a wide range of websites and organizations since it is designed to be a simple update for MySQL. It is considered a drop-in replacement for MySQL. To communicate with a Mari

Introduction of DBMS (Database Management System)

A Database Management System (DBMS) is a software solution designed to efficiently manage, organize, and retrieve data in a structured manner. It serves as a critical component in modern computing, enabling organizations to store, manipulate, and secure their data effectively. From small application

Difference between Neo4j and MariaDB

1. Neo4j : Neo4j is most famous graph database management system and it is also a NoSQL database system developed by Neo4j, Inc. Neo4j is different from Mysql or MongoDB as it has its features thatâ€™s makes it special compared to other Database Management System. Neo4j stores and present data in form

Difference between Oracle and MariaDB

1. Oracle: Oracle is commercial software developed by Oracle Corporation. Oracle widely uses RDBMS. Oracle allows quick and safe store and retrieval of data. It is used for running Online Transaction Processing and Data Warehousing. Oracle runs on the most major operating systems like Mac OS, Unix,

Difference Between MongoDB and MariaDB

When comparing MongoDB vs MariaDB, it is essential to understand their unique strengths and features. MongoDB is a document-oriented NoSQL database, ideal for flexibility and scalability with unstructured data.In respect, MariaDB is a relational database focused on MySQL compatibility by offering ro