Differences

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

--- servers:windows:mariadb [2025/11/15 04:45] – Sean Rhone
+++ servers:windows:mariadb [2025/11/28 21:42] (current) – mariadb-12.2.1-winx64.msi installs fine as-is, but was updated from previous MDEV fixed version Sean Rhone
@@ Line 2: / Line 2: @@
   * MariaDB Server
-  * :!: 2025/11/15: TODO: ''12.1'' -> ''12.2''
 ====== MariaDB ======
@@ Line 10: / Line 8: @@
   * https://mariadb.org/download/
+  * http://downloads.mariadb.org/mariadb/12.2.1/
-  * :!: 2025/11/15: ''12.2.0'' doesn't install as-is from MariaDB's website ([[https://jira.mariadb.org/browse/MDEV-37834|MDEV-37834]])
+  * Last tested: ''mariadb-12.2.1-winx64.msi''
-  * https://ci.mariadb.org/59755/amd64-windows-packages/
-  * Last tested: ''mariadb-12.2.0-winx64.msi''
   * No Development components or Third party tools
@@ Line 54: / Line 50: @@
 ====== Firewall ======
-****
+  DIR "%ProgramFiles%\MariaDB 12.2\bin\mariadbd.exe"
-  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"
+  "netsh.exe" advfirewall firewall add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%ProgramFiles%\MariaDB 12.2\bin\mariadbd.exe"
 ===== Delete Rule =====
@@ Line 65: / Line 61: @@
 ====== 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 =====
@@ Line 76: / Line 66: @@
 ==== Create User ====
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p
+  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" -p
   CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';
@@ Line 82: / Line 72: @@
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';
-  FLUSH PRIVILEGES;
+  FLUSH PRIVILEGES;EXIT;
-  EXIT
 ==== Script ====
@@ Line 97: / Line 85: @@
 @echo off
-"%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair
+"%ProgramFiles%\MariaDB 12.2\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair
 :: End</code>
@@ Line 112: / Line 100: @@
   * Weekly -> Recur every ''1'' weeks on ''Sunday''
-  * ''02:00:00 AM''
+  * ''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 ======