Quickstart Guides
Get started quickly with MariaDB Server using these quickstart guides. Follow step-by-step instructions to install, configure, and begin using MariaDB for your projects.
Official MariaDB Server install guide: Linux apt/dnf/yum commands, mariadb-secure-installation setup, systemctl status/start checks, Windows .msi installer.
This guide provides a walkthrough of the INSERT, UPDATE, and DELETE statements, demonstrating how to add, modify, and remove data in tables.
Learn how to perform essential SQL operations such as creating tables, inserting data, and using aggregate functions like MAX, MIN, and AVG.
Complete MariaDB basics guide: connect with mariadb -u/-p/-h, CREATE DATABASE/USE, CREATE TABLE with AUTO_INCREMENT, INSERT/SELECT/UPDATE/DELETE commands.
Learn how to modify existing table structures using the ALTER TABLE statement, including adding columns, changing types, and managing indexes.
This guide details how to connect to a MariaDB server using the command-line client, covering options for host, user, password, and protocol.
Diagnose and fix common MariaDB Server connection problems, such as "Can't connect to local server" and access-denied errors, with step-by-step troubleshooting.
Understand how to work with date and time values in MariaDB, including data types like DATETIME and TIMESTAMP, and useful temporal functions.
Learn how to efficiently import data into MariaDB tables from external files using the LOAD DATA INFILE statement.
This guide provides a conceptual overview of database indexes, explaining their purpose, different types, and when to use them for optimization.
Definitive MariaDB indexes guide: PRIMARY KEY, UNIQUE INDEX, INDEX, FULLTEXT types, CREATE/ALTER TABLE syntax, CREATE INDEX, SHOW INDEX, and EXPLAIN.
This guide introduces the different types of JOINs (INNER, LEFT, RIGHT, CROSS) and demonstrates how to combine data from multiple tables.
Explore complex join scenarios. This guide covers filtering joined data with WHERE clauses, handling dates, and aggregating results from multiple tables for deeper analysis.
Configure MariaDB Server to accept remote connections by setting bind-address, granting privileges for remote users, and opening the right firewall rules.
This guide explains the SELECT statement in detail, covering how to retrieve, filter, limit, and sort data from your MariaDB database.
A quick reference for core SQL statements including DDL (CREATE, DROP), DML (INSERT, UPDATE, DELETE), and TCL (COMMIT, ROLLBACK) commands.
This guide offers conventions and practical tips for designing SQL queries that are easier to read, understand, and debug.
This guide goes through several built-in string functions in MariaDB, grouping them by similar features, and providing examples of how they might be used.
Restore MariaDB data from mariadb-dump backup files using the mariadb client, including how to selectively restore a single table.
This guide explores MariaDB functions for performing calculations and modifications on date and time values, like DATE_ADD and DATE_SUB.
This guide indicates where the various system and status variables of MariaDB Server are found.
Create logical backups of MariaDB databases with the mariadb-dump utility, covering how to back up all databases, specific databases, or individual tables.
A beginner-friendly primer on using the mariadb command-line client to log in, create databases, and execute basic SQL commands.
Discover how to create and use views to simplify complex queries, restrict data access, and present a specific perspective of your data.
This section offers advice on writing and maintaining applications that use databases, covering schema design, code practices, and testing.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?