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

  * MariaDB ((https://mariadb.org/))
  * Server
  * [[information;realm_of_espionage|Realm of Espionage]]

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

===== 12.3 =====

  * https://mariadb.org/download/
  * http://downloads.mariadb.org/mariadb/12.3.1/

  * Last tested: ''mariadb-12.3.1-winx64.msi'' ((2026/02/27: ''12.3'' only with [[servers;windows;games;trinitycore_3.3.5_localhost|TC 3.3.5]]; other notes expect ''12.2''))

===== 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)]]

  * ''[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 ======

===== Delete Default Rule =====

****

  "%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="MariaDB 12.3 (x64)"

===== Block =====

****

  CD "%ProgramFiles%\MariaDB "*"\bin" && "%SystemRoot%\System32\netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%CD%\mysqld.exe"

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

****

  "%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="MariaDB Server"

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

===== Service =====

==== Create User ====

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

  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" & "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"

<code>
@echo off

TITLE MariaDB Maintenance
CD "%Temp%"

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

:: End</code>

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

==== Task Scheduler ====

  * Weekly (Sunday) ''07:10:00 AM''

  SCHTASKS /Create /SC "WEEKLY" /D "SUN" /TN "DB Maintenance" /TR "%SystemDrive%\www\scripts\mariadb\Maintenance.bat" /ST "07:10" /F