• MariaDB ¹⁾
• Server
• Realm of Espionage

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

• Last tested: mariadb-12.3.1-winx64.msi ²⁾

• [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

• TrinityCore 3.3.5 (localhost)

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

• [ ] Install as service
• [ ] Enable networking

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

• MySQL Host Address: . ³⁾

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

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"

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

"%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;

• Change --password

MKDIR "%SystemDrive%\www\scripts\mariadb" & "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"

@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

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

• 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