User Tools

Site Tools


servers:windows:mariadb

Information

  • MariaDB Server

MariaDB

  • 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

  • [x] Development components
    • [x] Client C API library (shared)
  • [ ] Install as service
  • [ ] Enable networking

SQLyog

  • MySQL Host Address: . 2)

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"
@echo off

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

:: End
"%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

1)
2025/09/26: mariadb-12.2.0-winx64.msi fails to install
2)
just a dot for socket connection on Windows; not localhost or 127.0.0.1
/srv/www/wiki/data/pages/servers/windows/mariadb.txt · Last modified: by Sean Rhone