Differences

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

--- servers:linux:mariadb [2024/08/25 18:15] – Sean Rhone
+++ servers:linux:mariadb [2024/12/31 05:35] (current) – Sean Rhone
@@ Line 3: / Line 3: @@
   * MariaDB ((https://mariadb.org/about))
   * [[Information:Realm of Espionage]]
-===== References =====
-  * https://mariadb.com/kb/en/configuring-mariadb-with-option-files/
-  * https://mariadb.com/kb/en/legacy-clients-and-utilities/
 ===== Prerequisites =====
   * [[linux;distros;server;fedora_server|Fedora Server]]
-  * [[linux;distros;fedora_workstation_gnome|Fedora Workstation (GNOME)]] ((for ''localhost'' game servers))
+  * [[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 ======
@@ Line 67: / Line 67: @@
   sudo mariadb
-  GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost' IDENTIFIED BY 'x';
+  CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';
+  GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';
   FLUSH PRIVILEGES;
@@ Line 75: / Line 77: @@
 ===== 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 '600' '/var/lib/mysql/auth/maintenance' && sync
+  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
 <code>