Differences

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

--- servers:linux:mariadb [2025/07/16 13:02] – Sean Rhone
+++ servers:linux:mariadb [2025/07/16 13:15] (current) – Sean Rhone
@@ Line 59: / Line 59: @@
   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair
-===== Create MySQL User =====
+===== Service =====
+==== Create MySQL User ====
   sudo mariadb
@@ Line 71: / Line 73: @@
   EXIT
-===== Authentication File =====
+==== Authentication File ====
-  sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/maintenance' && sudo chown -v -R 'mysql':'mysql' '/var/lib/mysql/auth' && sudo chmod -v '600' '/var/lib/mysql/auth/maintenance' && sync
+  sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/maintenance' && sudo chown -v -R 'mysql':'mysql' '/var/lib/mysql/auth' && sudo chmod -v '600' '/var/lib/mysql/auth/maintenance'
 <code>
 [mariadb-check]
 user=maintenance
-password=x</code>
+password=x
-===== Service =====
+# End</code>
+==== Service ====
   sudo -e '/etc/systemd/system/db-m.service'
@@ Line 90: / Line 94: @@
 Type=oneshot
 ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair
-ExecStartPost='/usr/bin/sync'</code>
+ExecStartPost='/usr/bin/sync'
-===== Timer =====
+# End</code>
+==== Timer ====
+  * Weekly
   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
@@ Line 106: / Line 114: @@
 [Install]
-WantedBy=timers.target</code>
+WantedBy=timers.target
+# End</code>
 ====== Notable Commands ======
@@ Line 120: / Line 130: @@
 ****
-  /var/lib/mysql/mysql.sock
+  /run/mysql/mysql.sock