MariaDB as a Services for Joget

Introduction

This tutorial guides you through configuring MariaDB to run automatically as a background Windows Service.

Installation Process

To install MariaDB as a Windows service, follow these steps:

Configure the Database Setting File

1. Navigate to your MariaDB folder:
   

   C:\Joget-DX9-Enterprise\mariadb-10.6.12-winx64\

2. Open the file named my.ini using a text editor, such as Notepad, and update the contents of the file with the following configuration:
   

   [mysqld]
   port=3307
   # The installation directory
   basedir="C:/Joget-DX9-Enterprise/mariadb-10.6.12-winx64"
   # The location of the database files
   datadir="C:/Joget-DX9-Enterprise/mariadb-10.6.12-winx64/data"
   
   character-set-server=utf8mb4
   collation-server=utf8mb4_unicode_ci
   innodb_strict_mode=0
   
   [client]
   port=3307

Install the Database

1. Right-click Command Prompt and click Run as administrator.
2. Paste the following command and press Enter:
   

   "C:\Joget-DX9-Enterprise\mariadb-10.6.12-winx64\bin\mysqld.exe" --defaults-file="C:\Joget-DX9-Enterprise\mariadb-10.6.12-winx64\my.ini" --install MariaDB

3. If successful, the console will output:
   

   [SC] CreateService SUCCESS

4. To verify the installation, open services.msc. You should now see MariaDB listed among your Windows services.