Differences

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

--- servers:windows:mariadb [2025/10/02 19:38] – 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 52: / Line 62: @@
 ====== Maintenance ======
-===== One-shot =====
+===== Service =====
-****
+==== Create User ====
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair
+  "%ProgramFiles%\MariaDB 12.2\bin\mariadb.exe" -u "root" -p
-==== Server Start ====
+  CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';
-****
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
+  GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';
-===== Scripts =====
+  FLUSH PRIVILEGES;EXIT;
-==== localhost ====
+==== Script ====
-  "notepad.exe" "%UserProfile%\Downloads\DB Maintenance.bat"
+  * :!: Change ''--password''
-<code>
-@echo off
-START "MariaDB Server" "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"
-TIMEOUT /T "2" /NOBREAK
-"%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair
-:: End</code>
-  "%UserProfile%\Downloads\DB Maintenance.bat"
-==== Server ====
   MKDIR "%SystemDrive%\www\scripts\mariadb"
@@ Line 91: / Line 85: @@
 @echo off
-"%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -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 97: / Line 91: @@
   "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
-====== Task Scheduler ======
+==== Task Scheduler ====
 ****
@@ Line 103: / Line 97: @@
   taskschd.msc
-===== Update =====
+=== Maintenance ===
-  * ''02:00:00 AM'' daily
+  * Weekly -> Recur every ''1'' weeks on ''Sunday''
-  * TODO: Password file/scripting
+  * ''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