Differences

This shows you the differences between two versions of the page.

--- servers:windows:mariadb [2025/11/28 21:42] – mariadb-12.2.1-winx64.msi installs fine as-is, but was updated from previous MDEV fixed version Sean Rhone
+++ servers:windows:mariadb [2026/02/27 23:55] (current) – [12.3] Sean Rhone
@@ Line 1: / Line 1: @@
 ====== Information ======
-  * MariaDB Server
+  * MariaDB ((https://mariadb.org/))
+  * Server
+  * [[information;realm_of_espionage|Realm of Espionage]]
 ====== MariaDB ======
-===== 12.2 =====
+===== 12.3 =====
   * https://mariadb.org/download/
-  * http://downloads.mariadb.org/mariadb/12.2.1/
+  * http://downloads.mariadb.org/mariadb/12.3.1/
-  * Last tested: ''mariadb-12.2.1-winx64.msi''
+  * 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''))
-  * No Development components or Third party tools
-  * Use UTF8 as default server's character set
 ===== Install Options =====
@@ Line 50: / Line 49: @@
 ====== Firewall ======
-  DIR "%ProgramFiles%\MariaDB 12.2\bin\mariadbd.exe"
+===== Delete Default Rule =====
-  "netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%ProgramFiles%\MariaDB 12.2\bin\mariadbd.exe"
+****
+  "%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 =====
@@ Line 58: / Line 65: @@
 ****
-  "netsh.exe" advfirewall firewall delete rule name="MariaDB Server"
+  "%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="MariaDB Server"
 ====== Maintenance ======
@@ Line 66: / Line 73: @@
 ==== Create User ====
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" -p
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root"
   CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';
@@ Line 78: / Line 85: @@
   * :!: Change ''--password''
-  MKDIR "%SystemDrive%\www\scripts\mariadb"
+  MKDIR "%SystemDrive%\www\scripts\mariadb" & "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
-  "notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
 <code>
 @echo off
-"%ProgramFiles%\MariaDB 12.2\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair
+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>
@@ Line 93: / Line 101: @@
 ==== Task Scheduler ====
-****
+  * Weekly (Sunday) ''07:10:00 AM''
-  taskschd.msc
-=== Maintenance ===
-  * Weekly -> Recur every ''1'' weeks on ''Sunday''
-  * ''07:10:00 AM''
-  DB Maintenance
-  "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
-===== One-shot =====
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.2\data\my.ini"
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair
-====== 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
+  SCHTASKS /Create /SC "WEEKLY" /D "SUN" /TN "DB Maintenance" /TR "%SystemDrive%\www\scripts\mariadb\Maintenance.bat" /ST "07:10" /F