MariaDB – Create Database
Creation or deletion of databases in MariaDB requires privileges typically only given to root users or admins. Under these accounts, you have two options for creating a database − the…
For MariaDB…
MariaDB – Connection
One way to establish a connection with MariaDB consists of using the MySQL binary at the command prompt. MYSQL Binary Review an example given below. [root@host]# mysql -u root -p…
MariaDB – PHP Syntax
MariaDB partners well with a wide variety of programming languages and frameworks such as PHP, C#, JavaScript, Ruby on Rails, Django, and more. PHP remains the most popular of all…
MariaDB – Administration
Before attempting to run MariaDB, first determine its current state, running or shutdown. There are three options for starting and stopping MariaDB − Run mysqld (the MariaDB binary).Run the mysqld_safe…
MariaDB – Installation
All downloads for MariaDB are located in the Download section of the official MariaDB foundation website. Click the link to the version you would like, and a list of downloads for multiple…
MariaDB – Introduction
A database application exists separate from the main application and stores data collections. Every database employs one or multiple APIs to create, access, manage, search, and replicate the data it…
MariaDB
MariaDB is a fork of the MySQL relational database management system. The original developers of MySQL created MariaDB after concerns raised by Oracle's acquisition of MySQL. This tutorial will provide…
MariaDB – Indexes & Statistics Tables
Indexes & Statistics Tables are tools for accelerating record retrieval. An index spawns an entry for each value within an indexed column. There are four types of indexes − Primary (one…
MariaDB – Alter Command
The Alter command provides a way to change an existing table's structure, meaning modifications like removing or adding columns, modifying indices, changing data types, or changing names. ALTER also waits…
MariaDB – Transactions
Transactions are sequential group operations. They function as a single unit, and do not terminate until all operations within the group execute successfully. A single failure in the group causes…