Differences

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

--- servers:linux:mariadb [2025/09/11 07:30] – [Authentication File] Sean Rhone
+++ servers:linux:mariadb [2026/01/01 03:22] (current) – Ubuntu -> oS TW Sean Rhone
@@ Line 64: / Line 64: @@
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';
-  FLUSH PRIVILEGES;
+  FLUSH PRIVILEGES;EXIT;
-  EXIT
 ==== Authentication File ====
-  sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/maintenance' && sudo chown 'mysql':'mysql' '/var/lib/mysql/auth/maintenance' && sudo chmod '600' '/var/lib/mysql/auth/maintenance'
+  sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/maintenance' && sudo chown 'mysql':'mysql' '/var/lib/mysql/auth/maintenance' && sudo chmod '0600' '/var/lib/mysql/auth/maintenance'
 <code>
@@ Line 88: / Line 86: @@
 Group=mysql
 Type=oneshot
+WorkingDirectory=/var/lib/mysql
 ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair
@@ Line 97: / Line 97: @@
 ==== 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 107: @@
 [Timer]
-OnCalendar=weekly
+OnCalendar=Sun *-*-* 07:10:00
 Persistent=true
@@ Line 114: / Line 114: @@
 # End</code>
+  sudo systemctl start 'db-m' && sudo systemctl status 'db-m' -l
 ====== Notable Commands ======