From 966278caafce0eb7eb27c2a3ffa24274b54da1b2 Mon Sep 17 00:00:00 2001
From: Sascha Schulz <sschulz@dh-software.de>
Date: Mo, 07 Jul 2025 16:24:04 +0200
Subject: [PATCH] replace mongodb by msql

---
 index.html |   84 ++++++++++++++++++++++++-----------------
 1 files changed, 49 insertions(+), 35 deletions(-)

diff --git a/index.html b/index.html
index 7cf03bd..0ef65ae 100644
--- a/index.html
+++ b/index.html
@@ -5072,7 +5072,7 @@
 						<p>Bearbeiten > Einstellungen > Protocols > TLS > (Pre)-Master-Secret log filename</p>
 					</section>
 					<section>
-						Einrichtung eines Datenbank-Servers (Beispiel MongoDB)
+						Einrichtung eines Datenbank-Servers (Beispiel MySql)
 					</section>
 					<section>
 						<p>Datenbank installieren:</p>
@@ -5081,50 +5081,64 @@
 								# Paketquellen aktualisieren
 								sudo apt update
 								
-								# Tools installieren
-								sudo apt install gnupg curl
+								# MySql installieren
+								sudo apt install mysql-server
 								
-								# GPG-Signatur herunterladen und importieren
-								curl -fsSL https://www.mongodb.org/static/pgp/server-8.0.asc | \
-								   sudo gpg -o /usr/share/keyrings/mongodb-server-8.0.gpg \
-								   --dearmor
-							</code>
-						</pre>
-					</section>
-					<section>
-						<pre>
-							<code class="bash" data-trim data-line-numbers>
-								# URL den Paketquellen hinzufügen
-								echo "deb [ arch=amd64,arm64 signed-by=/usr/share/keyrings/mongodb-server-8.0.gpg ] https://repo.mongodb.org/apt/ubuntu noble/mongodb-org/8.0 multiverse" | \
-									sudo tee /etc/apt/sources.list.d/mongodb-org-8.0.list
-								
-								# Paketquellen aktualisieren
-								sudo apt update
-								
-								# MongoDB installieren
-								sudo apt install mongodb-org
-							</code>
-						</pre>
-					</section>
-					<section>
-						<pre>
-							<code class="bash" data-trim data-line-numbers>
 								# systemd neuladen
 								sudo systemctl daemon-reload
 								
-								# Autostart aktivieren
-								sudo systemctl enable mongod
-								
-								# Dienst starten
-								sudo systemctl start mongod.service
+								# Status prüfen
+								sudo systemctl status mysql.service
 							</code>
 						</pre>
 					</section>
 					<section>
-						<p>Der Server sollte nun erreichbar sein:</p>
+						<p>Der Server sollte nun laufen:</p>
 						<pre>
 							<code class="bash" data-trim data-line-numbers>
-								mongosh
+								sudo systemctl status mysql.service
+							</code>
+						</pre>
+					</section>
+					<section>
+						<p>Root-Passwort setzen/ändern:</p>
+						<pre>
+							<code class="bash" data-trim data-line-numbers>
+								# Login mit generischen Credentials
+								sudo mysql --defaults-file=/etc/mysql/debian.cnf
+							</code>
+						</pre>
+						<pre>
+							<code class="sql" data-trim data-line-numbers>
+								ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'mypass';
+								exit;
+							</code>
+						</pre>
+						<pre>
+							<code class="bash" data-trim data-line-numbers>
+								# Server neustarten
+								sudo systemctl restart mysql.service
+							</code>
+						</pre>
+						<pre>
+							<code class="bash" data-trim data-line-numbers>
+								# Login mit neuen Credentials
+								mysql -uroot -p
+							</code>
+						</pre>
+					</section>
+					<section>
+						<pre>
+							<code class="sql" data-trim data-line-numbers>
+								CREATE DATABASE schema_name;
+								
+								use schema_name;
+								
+								create table stores (id int not null primary key, number varchar(5) not null);
+								
+								insert into stores (id, number) values (1, "10001");
+								
+								select * from stores;
 							</code>
 						</pre>
 					</section>

--
Gitblit v1.9.3