Differences

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

--- servers:linux:mariadb [2025/09/11 07:31] – [Authentication File] Sean Rhone
+++ servers:linux:mariadb [2026/04/30 23:49] (current) – [Service] Sean Rhone
@@ Line 42: / Line 42: @@
 ====== Initial Setup ======
-****
+  * Change the root password?: ''n''
   sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation
@@ Line 64: / Line 64: @@
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';
-  FLUSH PRIVILEGES;
+  FLUSH PRIVILEGES;EXIT;
-  EXIT
 ==== Authentication File ====
@@ Line 89: / Line 87: @@
 Type=oneshot
-ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair
+WorkingDirectory=/tmp
-ExecStartPost='/usr/bin/sync'
+ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair
 # End</code>
@@ Line 97: / Line 95: @@
 ==== Timer ====
-  * Weekly
+  * Weekly (Sunday) ''07:10:00 AM''
-  sudo -e '/etc/systemd/system/db-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'db-m.timer' --now && sudo systemctl start 'db-m' && sudo systemctl status 'db-m' -l
+  sudo -e '/etc/systemd/system/db-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'db-m.timer' --now
 <code>
@@ Line 107: / Line 105: @@
 [Timer]
-OnCalendar=weekly
+OnCalendar=Sun *-*-* 07:10:00
 Persistent=true
@@ Line 114: / Line 112: @@
 # End</code>
+  sudo systemctl start 'db-m' && sudo systemctl status 'db-m' -l
 ====== Notable Commands ======