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/08/27 20:00] – Sean Rhoneservers:linux:mariadb [2026/10/24 05:51] (current) – Sean Rhone
Line 1: Line 1:
 ====== Information ====== ====== Information ======
  
-  * MariaDB ((https://mariadb.org/about))+  * MariaDB 
 +  * Server
   * [[Information:Realm of Espionage]]   * [[Information:Realm of Espionage]]
  
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[linux:distros:server:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]]+  * [[linux:distros:server:arm:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]]
  
 ====== Settings ====== ====== Settings ======
Line 32: Line 33:
  
 # End</code> # End</code>
- 
-==== Verify ===== 
- 
-**** 
- 
-  sudo mariadb-admin variables | egrep 'utf8|networking|socket' 
  
 ====== Dependencies ====== ====== Dependencies ======
- 
-**** 
  
   sudo zypper install 'mariadb'   sudo zypper install 'mariadb'
  
 ====== Initial Setup ====== ====== Initial Setup ======
- 
-**** 
  
   sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation   sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation
Line 54: Line 45:
  
 ===== One-shot ===== ===== One-shot =====
- 
-**** 
  
   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair
Line 61: Line 50:
 ===== Service ===== ===== Service =====
  
-==== Create MySQL User ====+==== Create User ====
  
   sudo mariadb   sudo mariadb
Line 69: Line 58:
   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 -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 'mysql':'mysql' '/var/lib/mysql/auth/maintenance' && sudo chmod '0600' '/var/lib/mysql/auth/maintenance'
  
 <code> <code>
Line 93: Line 80:
 Group=mysql Group=mysql
 Type=oneshot Type=oneshot
 +
 +WorkingDirectory=/tmp
 +
 ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair
-ExecStartPost='/usr/bin/sync' 
  
 # End</code> # End</code>
Line 100: Line 89:
 ==== Timer ==== ==== 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> <code>
Line 110: Line 99:
  
 [Timer] [Timer]
-OnCalendar=weekly+OnCalendar=Sun *-*-* 07:10:00
 Persistent=true Persistent=true
  
Line 117: Line 106:
  
 # End</code> # End</code>
 +
 +  sudo systemctl start 'db-m' && sudo systemctl status 'db-m' -l
  
 ====== Notable Commands ====== ====== Notable Commands ======
  
-===== Show Users on Server =====+===== Settings =====
  
-****+  sudo mariadb-admin variables | egrep 'utf8|networking|socket' 
 + 
 +===== Show Users on Server =====
  
   select User,Host from mysql.user;   select User,Host from mysql.user;
  
 ===== Socket File ===== ===== Socket File =====
- 
-**** 
  
   /run/mysql/mysql.sock   /run/mysql/mysql.sock
/srv/www/wiki/data/attic/servers/linux/mariadb.1756339257.txt.gz · Last modified: by Sean Rhone