RoE | Wiki

User Tools

Site Tools

Trace:
servers:linux: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:linux:mariadb [2025/07/16 13:10] – [Service] Sean Rhoneservers:linux:mariadb [2025/07/16 13:15] (current) – Sean Rhone
Line 59: Line 59:
   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair
  
-===== Create MySQL User =====+===== Service ===== 
 + 
 +==== Create MySQL User ====
  
   sudo mariadb   sudo mariadb
Line 71: Line 73:
   EXIT   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'   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'
Line 82: Line 84:
 # End</code> # End</code>
  
-===== Service =====+==== Service ====
  
   sudo -e '/etc/systemd/system/db-m.service'   sudo -e '/etc/systemd/system/db-m.service'
Line 96: Line 98:
 # End</code> # End</code>
  
-===== Timer =====+==== 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   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 110: Line 114:
  
 [Install] [Install]
-WantedBy=timers.target</code>+WantedBy=timers.target 
 + 
 +# End</code>
  
 ====== Notable Commands ====== ====== Notable Commands ======
/srv/www/wiki/data/attic/servers/linux/mariadb.1752685832.txt.gz · Last modified: by Sean Rhone