Differences

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

--- servers:windows:mariadb [2026/02/13 07:19] – [12.2] Sean Rhone
+++ servers:windows:mariadb [2026/02/27 23:55] (current) – [12.3] Sean Rhone
@@ Line 7: / Line 7: @@
 ====== 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''))
-  * TODO: ''mariadb-12.3.1-winx64.msi''
-  * No Development components or Third party tools
-  * Use UTF8 as default server's character set
 ===== Install Options =====
@@ Line 53: / Line 49: @@
 ====== Firewall ======
-  "netsh.exe" advfirewall firewall delete rule name="MariaDB 12.2 (x64)"
+===== Delete Default Rule =====
-  CD "%ProgramFiles%\MariaDB "*"\bin" && "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 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 61: / Line 65: @@
 ****
-  "netsh.exe" advfirewall firewall delete rule name="MariaDB Server"
+  "%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="MariaDB Server"
 ====== Maintenance ======
@@ Line 69: / Line 73: @@
 ==== Create User ====
-  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root"
+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root"
   CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';
@@ Line 81: / Line 85: @@
   * :!: Change ''--password''
-  MKDIR "%SystemDrive%\www\scripts\mariadb" & "notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
+  MKDIR "%SystemDrive%\www\scripts\mariadb" & "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
 <code>
@@ Line 89: / Line 93: @@
 CD "%Temp%"
-"%ProgramFiles%\MariaDB 12.2\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair
+"%ProgramFiles%\MariaDB 12.3\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair
 :: End</code>
@@ Line 100: / Line 104: @@
   SCHTASKS /Create /SC "WEEKLY" /D "SUN" /TN "DB Maintenance" /TR "%SystemDrive%\www\scripts\mariadb\Maintenance.bat" /ST "07:10" /F
-===== 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" -o -A -f -e --auto-repair