mariadb-12.2.0-winx64.msi
fails to installservers:windows:mariadb
Table of Contents
Information
- MariaDB Server
MariaDB
- Last tested:
mariadb-12.1.1-winx64.msi
1)
- 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
- Last tested:
SQLyog-13.3.1-0.x64Community.exe
- 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 onSunday
02:00:00 AM
DB Maintenance
"%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
TODOs
auth File
- May be useful for automating DB backups for websites
RUNAS
NT SERVICE\MariaDB
/srv/www/wiki/data/pages/servers/windows/mariadb.txt · Last modified: by Sean Rhone