Differences

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

--- servers:windows:mariadb [2026/02/27 23:55] – [12.3] Sean Rhone
+++ servers:windows:mariadb [2026/05/30 19:11] (current) – 12.3 -> 13.0 Sean Rhone
@@ Line 7: / Line 7: @@
 ====== MariaDB ======
-===== 12.3 =====
+===== 13.0 =====
   * https://mariadb.org/download/
-  * http://downloads.mariadb.org/mariadb/12.3.1/
+  * https://mariadb.org/mariadb/all-releases/
-  * 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''))
+  * Last tested: ''mariadb-13.0.1-winx64.msi''
 ===== Install Options =====
@@ Line 53: / Line 53: @@
 ****
-  "%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="MariaDB 12.3 (x64)"
+  "%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="MariaDB 13.0 (x64)"
 ===== Block =====
-****
+  * [[servers;windows;nginx;friendica#firewall|Friendica]] with WSL needs ''remoteip=localsubnet''
+  CD "%ProgramFiles%\MariaDB "*"\bin"
-  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 add rule name="MariaDB Server" dir="in" action="block" profile="any" program="%CD%\mysqld.exe"
 ===== Delete Rule =====
@@ Line 73: / Line 75: @@
 ==== Create User ====
-  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root"
+  "%ProgramFiles%\MariaDB 13.0\bin\mariadb.exe" -u "root"
   CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';
@@ Line 93: / Line 95: @@
 CD "%Temp%"
-"%ProgramFiles%\MariaDB 12.3\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair
+"%ProgramFiles%\MariaDB 13.0\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair
 :: End</code>
@@ Line 103: / Line 105: @@
   * 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
+  "%SystemRoot%\System32\schtasks.exe" /Create /SC "WEEKLY" /D "SUN" /TN "DB Maintenance" /TR "%SystemDrive%\www\scripts\mariadb\Maintenance.bat" /ST "07:10" /F