Differences

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

--- servers:linux:mariadb [2024/08/13 16:34] – created Sean Rhone
+++ servers:linux:mariadb [2024/12/31 05:35] (current) – Sean Rhone
@@ Line 4: / Line 4: @@
   * [[Information:Realm of Espionage]]
-===== References =====
+===== Prerequisites =====
-  * https://mariadb.com/kb/en/configuring-mariadb-with-option-files/
+  * [[linux;distros;server;fedora_server|Fedora Server]]
-  * https://mariadb.com/kb/en/legacy-clients-and-utilities/
+  * [[linux;distros;fedora_workstation_gnome|Fedora Workstation]] (([[servers:linux:games:trinitycore_3.3.5_localhost]]))
-===== Prerequisites =====
+===== Resources =====
-  * [[distros:fedora_server|Fedora Server]]
+  * https://mariadb.com/kb/en/configuring-mariadb-with-option-files/
+  * https://mariadb.com/kb/en/legacy-clients-and-utilities/
 ====== Settings ======
@@ Line 66: / 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 74: / 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>