Differences

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

--- servers:windows:mariadb [2025/10/02 20:22] – [Task Scheduler] 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 4: / Line 4: @@
 ====== MariaDB ======
+===== 12.2 =====
   * https://mariadb.org/download/
-  * https://downloads.mariadb.org/rest-api/mariadb/
+  * http://downloads.mariadb.org/mariadb/12.2.1/
-  * Last tested: ''mariadb-12.1.1-winx64.msi'' ((2025/09/26: ''mariadb-12.2.0-winx64.msi'' fails to install))
+  * Last tested: ''mariadb-12.2.1-winx64.msi''
   * No Development components or Third party tools
@@ Line 28: / Line 31: @@
   * ''[x]'' Enable networking
-==== TrinityCore ====
+==== World of Warcraft ====
-  * [[servers;windows;games;trinitycore_3.3.5_localhost|3.3.5 (localhost)]]
+  * [[servers;windows;games;trinitycore_3.3.5_localhost|TrinityCore 3.3.5 (localhost)]]
   * ''[x]'' Development components
@@ Line 37: / Line 40: @@
   * ''[ ]'' Install as service
   * ''[ ]'' Enable networking
+====== SQLyog ======
+  * https://github.com/webyog/sqlyog-community/wiki/Downloads
+  * Last tested: ''SQLyog-13.3.1-0.x64Community.exe''
+  * MySQL Host Address: ''.'' ((just a dot for socket connection on Windows; not ''localhost'' or ''127.0.0.1''))
 ====== 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 51: / 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 62: / 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 68: / Line 72: @@
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';
-  FLUSH PRIVILEGES;
+  FLUSH PRIVILEGES;EXIT;
-  EXIT
 ==== Script ====
@@ Line 83: / 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 98: / 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 ======