replace mongodb by msql

Sascha Schulz

vor 5 Tagen 966278caafce0eb7eb27c2a3ffa24274b54da1b2

 index.html

@@ -5007,7 +5007,7 @@
                        sudo cp example.conf example-ssl.conf
                     </code>
                  </pre>
                  <p>Den vhost für HTTTP / Port 80 so konfigurieren, dass dieser nach HTTPS / Port 443 weiterleitet:</p>
                  <p>Den vhost für HTTP / Port 80 so konfigurieren, dass dieser nach HTTPS / Port 443 weiterleitet:</p>
                  <pre>
                     <code class="bash" data-trim data-line-numbers>
                        # example.conf
@@ -5033,6 +5033,12 @@
                        SSLEngine on
                        SSLCertificateFile "/.../cert.pem"
                        SSLCertificateKeyFile "/.../key.pem"
                     </code>
                  </pre>
                  <pre>
                     <code class="bash" data-trim data-line-numbers>
                        # neuen vhost für SSL aktivieren:
                        sudo a2ensite example-ssl.conf
                     </code>
                  </pre>
                  <p>Anschließend den Apache neu starten:</p>
@@ -5065,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>