replace mongodb by msql

Sascha Schulz

vor 5 Tagen 966278caafce0eb7eb27c2a3ffa24274b54da1b2

replace mongodb by msql

 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>