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 |   71 +++++++++++++++++++++++++++++++++++
 1 files changed, 71 insertions(+), 0 deletions(-)

diff --git a/index.html b/index.html
index 74b9993..0ef65ae 100644
--- a/index.html
+++ b/index.html
@@ -5071,6 +5071,77 @@
 						<p>Eben angegebene Datei in Wireshark einstellen:</p>
 						<p>Bearbeiten > Einstellungen > Protocols > TLS > (Pre)-Master-Secret log filename</p>
 					</section>
+					<section>
+						Einrichtung eines Datenbank-Servers (Beispiel MySql)
+					</section>
+					<section>
+						<p>Datenbank installieren:</p>
+						<pre>
+							<code class="bash" data-trim data-line-numbers>
+								# Paketquellen aktualisieren
+								sudo apt update
+								
+								# MySql installieren
+								sudo apt install mysql-server
+								
+								# systemd neuladen
+								sudo systemctl daemon-reload
+								
+								# Status prüfen
+								sudo systemctl status mysql.service
+							</code>
+						</pre>
+					</section>
+					<section>
+						<p>Der Server sollte nun laufen:</p>
+						<pre>
+							<code class="bash" data-trim data-line-numbers>
+								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>
 				</section>
 			</div>
 		</div>

--
Gitblit v1.9.3