MariaDB Setup Guide - ajgillis04/GillisDockerDepot GitHub Wiki

MariaDB Setup Guide

Introduction

MariaDB is a popular open-source relational database management system. It is a fork of MySQL and provides a robust and scalable database solution.

Prerequisites

  • Docker installed
  • MariaDB container running in your Docker stack

Configuration Steps

Step 1: Accessing the MariaDB Container

  1. Open your terminal.
  2. Use the following command to access the MariaDB container:

⚠️ Hint: Bug #127 - Initial pass not working; performed password reset as initial fix.

docker exec -it mariadb.<HOST_NAME> /bin/bash
/usr/bin/mariadb-secure-installation

Steps:

  1. Push Enter.
  2. Enable unix_socket authentication? [Y/n]: y and press Enter.
  3. Change the root password? [Y/n]: y and press Enter again.
  4. Enter a password and press enter, and Re-enter new password, press enter
  5. Remove anonymous users? [Y/n]: y and press Enter.
  6. Disallow root login remotely? [Y/n]: n and press Enter.
  7. Remove test database and access to it? [Y/n]: y and press Enter.
  8. Reload privilege tables now? [Y/n]: y and press Enter.
  9. Exit.
⚠️ **GitHub.com Fallback** ⚠️