Differences

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

--- servers:linux:mariadb [2025/07/16 12:51] – Sean Rhone
+++ servers:linux:mariadb [2025/10/16 23:25] (current) – [Create User] Sean Rhone
@@ Line 1: / Line 1: @@
 ====== Information ======
-  * MariaDB ((https://mariadb.org/about))
+  * MariaDB
+  * Server
   * [[Information:Realm of Espionage]]
@@ Line 7: / Line 8: @@
   * [[linux:distros:server:opensuse_tumbleweed_server|openSUSE Tumbleweed (Server)]]
-===== Resources =====
-  * https://mariadb.com/kb/en/configuring-mariadb-with-option-files/
-  * https://mariadb.com/kb/en/legacy-clients-and-utilities/
 ====== Settings ======
@@ Line 34: / Line 30: @@
 max_binlog_size = '100M'
 skip-networking = 'On'
-table_definition_cache = '1400'</code>
+table_definition_cache = '1400'
-==== Verify =====
+# End</code>
-****
-  sudo mariadb-admin variables | egrep 'utf8|networking|socket'
 ====== Dependencies ======
@@ Line 62: / Line 54: @@
   sudo mariadb-check --optimize --all-databases --force --extended --auto-repair
-===== Create MySQL User =====
+===== Service =====
+==== Create User ====
   sudo mariadb
@@ Line 70: / Line 64: @@
   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>
 [mariadb-check]
 user=maintenance
-password=x</code>
+password=x
-===== Service =====
+# End</code>
+==== Service ====
   sudo -e '/etc/systemd/system/db-m.service'
@@ Line 92: / Line 86: @@
 Group=mysql
 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>
-===== 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>
@@ Line 109: / Line 109: @@
 [Install]
-WantedBy=timers.target</code>
+WantedBy=timers.target
+# End</code>
+  sudo systemctl start 'db-m' && sudo systemctl status 'db-m' -l
 ====== Notable Commands ======
+===== Settings =====
+****
+  sudo mariadb-admin variables | egrep 'utf8|networking|socket'
 ===== Show Users on Server =====
@@ Line 123: / 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'