User Tools

Site Tools


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/09/11 07:28] – [Authentication File] Sean Rhoneservers:linux:mariadb [2025/10/16 23:25] (current) – [Create User] Sean Rhone
Line 64: Line 64:
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';
  
-  FLUSH PRIVILEGES; +  FLUSH PRIVILEGES;EXIT;
- +
-  EXIT+
  
 ==== Authentication File ==== ==== Authentication File ====
  
-  sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/maintenance' && sudo chown -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 'mysql':'mysql' '/var/lib/mysql/auth/maintenance' && sudo chmod '0600' '/var/lib/mysql/auth/maintenance'
  
 <code> <code>
Line 99: Line 97:
   * Weekly   * 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
  
 <code> <code>
Line 114: Line 112:
  
 # End</code> # End</code>
 +
 +  sudo systemctl start 'db-m' && sudo systemctl status 'db-m' -l
  
 ====== Notable Commands ====== ====== Notable Commands ======
/srv/www/wiki/data/attic/servers/linux/mariadb.1757590136.txt.gz · Last modified: by Sean Rhone