Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
debian:guacamole-debian:start [2018/01/22 12:38] – [MySQL-DB Upgrade] michael | debian:guacamole-debian:start [2019/08/06 15:49] (current) – [Vorbereitungen für Guacamole] michael | ||
---|---|---|---|
Line 21: | Line 21: | ||
<WRAP center box 100%> | <WRAP center box 100%> | ||
+ | <wrap em> | ||
< | < | ||
- | # systemctl start mariadb.service | + | # openssl rand -base64 30 > / |
- | # systemctl enable | + | </ |
+ | |||
+ | <sxh plain; gutter: false;> | ||
+ | Tb/ | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | # systemctl start mysql.service | ||
+ | # systemctl enable | ||
# mysql_secure_installation | # mysql_secure_installation | ||
Line 29: | Line 38: | ||
<sxh plain; gutter: false;> | <sxh plain; gutter: false;> | ||
- | Change the root password? [Y/n] n | + | Enter current password for root (enter for none): Enter |
- | Remove anonymous users? [Y/n] y | + | Set root password? [Y/n]: Y |
- | Disallow root login remotely? [Y/n] y | + | New password: ****************************** |
- | Remove test database and access to it? [Y/n] y | + | Re-enter new password: ****************************** |
- | Reload privilege tables now? [Y/n] y | + | Remove anonymous users? [Y/n]: Y |
+ | Disallow root login remotely? [Y/n]: Y | ||
+ | Remove test database and access to it? [Y/n]: Y | ||
+ | Reload privilege tables now? [Y/n]: Y | ||
All done! | All done! | ||
Line 78: | Line 90: | ||
==== Einrichten der Guacamole Datenbank ==== | ==== Einrichten der Guacamole Datenbank ==== | ||
- | In diesem Schritt wird mit dem **DB-root** Benutzer auf den **MySQL Server** verbunden, die Datenbank // | + | |
+ | In diesem Schritt wird mit dem **DB-root** Benutzer auf den **MySQL Server** verbunden | ||
<WRAP center box 100%> | <WRAP center box 100%> | ||
< | < | ||
- | # mysql -u root -p | + | # mysql -u root --password=$(cat / |
</ | </ | ||
< | < | ||
CREATE DATABASE guacamole; | CREATE DATABASE guacamole; | ||
- | CREATE USER ' | + | CREATE USER ' |
GRANT SELECT, | GRANT SELECT, | ||
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
Line 93: | Line 106: | ||
</ | </ | ||
</ | </ | ||
- | |||
Nun wird die Guacamole **//DB Authentifizierungs-Library// | Nun wird die Guacamole **//DB Authentifizierungs-Library// |