RoE | Wiki

User Tools

Site Tools

Trace: • dance_dance_revolution_pad • fedora_workstation_gnome • gnome_hdmi_full_rgb • rpi_flashrom • dota_2_steamcmd • wine_wayland_vulkan_wow_335 • mariadb • pc_benchmarking • guild_wars_2 • flightgear_sidewinder_joystick
servers:windows:mariadb

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
servers:windows:mariadb [2025/11/15 04:45] – Sean Rhoneservers:windows:mariadb [2026/02/27 23:55] (current) – [12.3] Sean Rhone
Line 1: Line 1:
 ====== Information ====== ====== Information ======
  
-  * MariaDB Server +  * MariaDB ((https://mariadb.org/)) 
- +  * Server 
-  * :!: 2025/11/15: TODO: ''12.1'' -> ''12.2''+  * [[information;realm_of_espionage|Realm of Espionage]]
  
 ====== MariaDB ====== ====== MariaDB ======
  
-===== 12.2 =====+===== 12.3 =====
  
   * https://mariadb.org/download/   * https://mariadb.org/download/
 +  * http://downloads.mariadb.org/mariadb/12.3.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.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''))
-  * https://ci.mariadb.org/59755/amd64-windows-packages/ +
- +
-  * Last tested: ''mariadb-12.2.0-winx64.msi'' +
- +
-  * No Development components or Third party tools +
-  * Use UTF8 as default server's character set+
  
 ===== Install Options ===== ===== Install Options =====
Line 53: Line 48:
  
 ====== Firewall ====== ====== Firewall ======
 +
 +===== Delete Default Rule =====
  
 **** ****
  
-  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"+  "%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="MariaDB 12.3 (x64)"
  
-===== Delete Rule =====+===== Block =====
  
 **** ****
  
-  "netsh.exe" advfirewall firewall delete rule name="MariaDB Server"+  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"
  
-====== Maintenance ======+===== Delete Rule =====
  
-===== One-shot =====+****
  
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadbd.exe" --defaults-file="%ProgramFiles%\MariaDB 12.1\data\my.ini"+  "%SystemRoot%\System32\netsh.exe" advfirewall firewall delete rule name="MariaDB Server"
  
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" -u "root" -p -o -A -f -e --auto-repair+====== Maintenance ======
  
 ===== Service ===== ===== Service =====
Line 76: Line 73:
 ==== Create User ==== ==== Create User ====
  
-  "%ProgramFiles%\MariaDB 12.1\bin\mariadb.exe" -u "root" -p+  "%ProgramFiles%\MariaDB 12.3\bin\mariadb.exe" -u "root"
  
   CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';   CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';
Line 82: Line 79:
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';
  
-  FLUSH PRIVILEGES; +  FLUSH PRIVILEGES;EXIT;
- +
-  EXIT+
  
 ==== Script ==== ==== Script ====
Line 90: Line 85:
   * :!: Change ''--password''   * :!: Change ''--password''
  
-  MKDIR "%SystemDrive%\www\scripts\mariadb" +  MKDIR "%SystemDrive%\www\scripts\mariadb" & "%SystemRoot%\System32\notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"
- +
-  "notepad.exe" "%SystemDrive%\www\scripts\mariadb\Maintenance.bat"+
  
 <code> <code>
 @echo off @echo off
  
-"%ProgramFiles%\MariaDB 12.1\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair+TITLE MariaDB Maintenance 
 +CD "%Temp%" 
 + 
 +"%ProgramFiles%\MariaDB 12.3\bin\mariadb-check.exe" --user="maintenance" --password="x" -o -A -f -e --auto-repair
  
 :: End</code> :: End</code>
Line 105: Line 101:
 ==== Task Scheduler ==== ==== Task Scheduler ====
  
-**** +  * Weekly (Sunday) ''07:10:00 AM''
- +
-  taskschd.msc +
- +
-=== Maintenance === +
- +
-  * Weekly -> Recur every ''1'' weeks on ''Sunday'' +
-  * ''02:00:00 AM'' +
- +
-  DB Maintenance +
- +
-  "%SystemDrive%\www\scripts\mariadb\Maintenance.bat" +
- +
-====== 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+  SCHTASKS /Create /SC "WEEKLY" /D "SUN" /TN "DB Maintenance" /TR "%SystemDrive%\www\scripts\mariadb\Maintenance.bat" /ST "07:10" /F
  
/usr/local/www/wiki/data/attic/servers/windows/mariadb.1763199951.txt.gz · Last modified: by Sean Rhone