====== Information ======

  * MariaDB Server

====== MariaDB ======

  * https://mariadb.org/download/
  * https://downloads.mariadb.org/rest-api/mariadb/
  * Last tested: ''mariadb-12.1.1-winx64.msi'' ((2025/09/26: ''mariadb-12.2.0-winx64.msi'' fails to install))

  * No Development components or Third party tools
  * Use UTF8 as default server's character set

===== Install Options =====

  * ''[x]'' MariaDB Server
    * ''[x]'' Database instance
    * ''[x]'' Client Programs
    * ''[x]'' Backup utilities
  * ''[ ]'' Development components
    * ''[ ]'' Client C API library (shared)
  * ''[ ]'' Third party tools
    * ''[ ]'' HeidiSQL

  * ''[x]'' Use UTF8 as default server's character set

  * ''[x]'' Install as service
  * ''[x]'' Enable networking

==== World of Warcraft ====

  * [[servers;windows;games;trinitycore_3.3.5_localhost|TrinityCore 3.3.5 (localhost)]]
  * [[servers;windows;games;mangos_one_tbc_localhost|MaNGOS One (localhost)]]

  * ''[x]'' Development components
    * ''[x]'' Client C API library (shared)

  * ''[ ]'' Install as service
  * ''[ ]'' Enable networking

====== SQLyog ======

  * https://github.com/webyog/sqlyog-community/wiki/Downloads
  * Last tested: ''SQLyog-13.3.1-0.x64Community.exe''

  * MySQL Host Address: ''.'' ((just a dot for socket connection on Windows; not ''localhost'' or ''127.0.0.1''))

====== Firewall ======

****

  DIR "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" && "netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe"

===== Delete Rule =====

****

  "netsh.exe" advfirewall firewall delete rule name="MariaDB Server"

====== Maintenance ======

===== One-shot =====

  "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"

  "%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair

===== Service =====

==== Create User ====

  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p

  CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';

  GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';

  FLUSH PRIVILEGES;

  EXIT

==== Script ====

  * :!: Change ''--password''

  MKDIR "%SystemDrive%\www\scripts\mariadb"

  "notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"

<code>
@echo off

"%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair

:: End</code>

  "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"

==== Task Scheduler ====

****

  taskschd.msc

=== Maintenance ===

  * Weekly -> Recur every ''1'' weeks on ''Sunday''
  * ''02:00:00 AM''

  DB Maintenance

  "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"

====== TODOs ======

===== auth File =====

  * [[servers;linux;mariadb#authentication_file]]
  * https://stackoverflow.com/questions/75051716/cant-use-mariadb-windows-user-group-account-to-give-mariadb-permission-to-acc/75070761#75070761
  * May be useful for automating DB backups for websites

  RUNAS

  NT SERVICE\MariaDB