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/05/16 21:39] – external edit 127.0.0.1servers:linux:mariadb [2025/10/16 23:25] (current) – [Create User] 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;fedora_server|Fedora Server]] +  * [[linux:distros:server:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]]
-  * [[linux;distros;fedora_workstation_gnome|Fedora Workstation]] (([[servers:linux:games:trinitycore_3.3.5_localhost]])) +
- +
-===== Resources ===== +
- +
-  * https://mariadb.com/kb/en/configuring-mariadb-with-option-files/ +
-  * https://mariadb.com/kb/en/legacy-clients-and-utilities/+
  
 ====== Settings ====== ====== Settings ======
Line 35: Line 30:
 max_binlog_size = '100M' max_binlog_size = '100M'
 skip-networking = 'On' skip-networking = 'On'
-table_definition_cache = '1400'</code>+table_definition_cache = '1400'
  
-==== Verify ===== +# End</code>
- +
-**** +
- +
-  sudo mariadb-admin variables | egrep 'utf8|networking|socket'+
  
 ====== Dependencies ====== ====== Dependencies ======
Line 47: Line 38:
 **** ****
  
-  sudo dnf install 'mariadb-server'+  sudo zypper install 'mariadb'
  
 ====== Initial Setup ====== ====== Initial Setup ======
Line 63: Line 54:
   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 User ====
  
   sudo mariadb   sudo mariadb
Line 71: 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 -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 'mysql':'mysql' '/var/lib/mysql/auth/maintenance' && sudo chmod '0600' '/var/lib/mysql/auth/maintenance'
  
 <code> <code>
 [mariadb-check] [mariadb-check]
 user=maintenance user=maintenance
-password=x</code>+password=x
  
-===== Service =====+# End</code> 
 + 
 +==== Service ====
  
   sudo -e '/etc/systemd/system/db-m.service'   sudo -e '/etc/systemd/system/db-m.service'
Line 93: Line 86:
 Group=mysql Group=mysql
 Type=oneshot Type=oneshot
 +
 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'</code> 
  
-===== Timer =====+ExecStartPost='/usr/bin/sync'
  
-  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+# End</code> 
 + 
 +==== Timer ==== 
 + 
 +  * Weekly 
 + 
 +  sudo -e '/etc/systemd/system/db-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'db-m.timer' --now
  
 <code> <code>
Line 110: Line 109:
  
 [Install] [Install]
-WantedBy=timers.target</code>+WantedBy=timers.target 
 + 
 +# End</code> 
 + 
 +  sudo systemctl start 'db-m' && sudo systemctl status 'db-m' -l
  
 ====== Notable Commands ====== ====== Notable Commands ======
 +
 +===== Settings =====
 +
 +****
 +
 +  sudo mariadb-admin variables | egrep 'utf8|networking|socket'
  
 ===== Show Users on Server ===== ===== Show Users on Server =====
Line 124: Line 133:
 **** ****
  
-  /var/lib/mysql/mysql.sock+  /run/mysql/mysql.sock 
 + 
 +===== No sudo auth file ===== 
 + 
 +  * Uses an ''auth'' file; can use ''mariadb'' with user/pass flags instead of ''sudo'' 
 + 
 +  sudo mariadb-dump --defaults-extra-file='/var/lib/mysql/auth/piwigo' --single-transaction 'piwigo' -r ~/'piwigo-database-manual-'$(date +%Y-%m-%d)'.sql'
  
/srv/www/wiki/data/attic/servers/linux/mariadb.1747445948.txt.gz · Last modified: by 127.0.0.1