09.10.2021, 08:12
Datenbanken für OpenSim auf Ubuntu 20.04.3 LTS anlegen:
Einloggen auf den Server per ssh:
salatbieger@kiste:~$ ssh poeserbube@IP-Adresse -pPortangabe
poeserbube@IP-Adresse password:
Welcome to Ubuntu 20.04.3 LTS (GNU/Linux 5.4.0-88-generic x86_64)
* Documentation: https://help.ubuntu.com
* Management: https://landscape.canonical.com
* Support: https://ubuntu.com/advantage
System information as of Sat Oct 9 05:12:59 UTC 2021
System load: 0.52 Processes: 140
Usage of /: 92.3% of 195.86GB Users logged in: 0
Memory usage: 8% IPv4 address for enp4s0: IP-Adresse
Swap usage: 0%
=> / is using 92.3% of 195.86GB
* Super-optimized for small spaces - read how we shrank the memory
footprint of MicroK8s to make it the smallest full K8s around.
https://ubuntu.com/blog/microk8s-memory-optimisation
10 updates can be applied immediately.
2 of these updates are standard security updates.
To see these additional updates run: apt list --upgradable
Last login: Fri Oct 8 14:56:30 2021 from ganz weit weg
Anmelden bei mysql:
poeserbube@Server:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.26-0ubuntu0.20.04.3 (Ubuntu)
Copyright © 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Datenbanken für OpenSim anlegen:
mysql> create database kleinemaus1;
Query OK, 1 row affected (0.15 sec)
mysql> create database kleinemaus2;
Query OK, 1 row affected (0.18 sec)
mysql> create database kleinemaus3;
Query OK, 1 row affected (0.14 sec)
mysql> create database kleinemaus4;
Query OK, 1 row affected (0.16 sec)
Datenbanken anzeigen:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| kleinemaus1 |
| kleinemaus2 |
| kleinemaus3 |
| kleinemaus4 |
| information_schema |
| mysql |
| performance_schema |
| miezmiez |
| sys |
+--------------------+
rows in set (0.01 sec)
mysql> exit
Bye
Einloggen auf den Server per ssh:
salatbieger@kiste:~$ ssh poeserbube@IP-Adresse -pPortangabe
poeserbube@IP-Adresse password:
Welcome to Ubuntu 20.04.3 LTS (GNU/Linux 5.4.0-88-generic x86_64)
* Documentation: https://help.ubuntu.com
* Management: https://landscape.canonical.com
* Support: https://ubuntu.com/advantage
System information as of Sat Oct 9 05:12:59 UTC 2021
System load: 0.52 Processes: 140
Usage of /: 92.3% of 195.86GB Users logged in: 0
Memory usage: 8% IPv4 address for enp4s0: IP-Adresse
Swap usage: 0%
=> / is using 92.3% of 195.86GB
* Super-optimized for small spaces - read how we shrank the memory
footprint of MicroK8s to make it the smallest full K8s around.
https://ubuntu.com/blog/microk8s-memory-optimisation
10 updates can be applied immediately.
2 of these updates are standard security updates.
To see these additional updates run: apt list --upgradable
Last login: Fri Oct 8 14:56:30 2021 from ganz weit weg
Anmelden bei mysql:
poeserbube@Server:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.26-0ubuntu0.20.04.3 (Ubuntu)
Copyright © 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Datenbanken für OpenSim anlegen:
mysql> create database kleinemaus1;
Query OK, 1 row affected (0.15 sec)
mysql> create database kleinemaus2;
Query OK, 1 row affected (0.18 sec)
mysql> create database kleinemaus3;
Query OK, 1 row affected (0.14 sec)
mysql> create database kleinemaus4;
Query OK, 1 row affected (0.16 sec)
Datenbanken anzeigen:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| kleinemaus1 |
| kleinemaus2 |
| kleinemaus3 |
| kleinemaus4 |
| information_schema |
| mysql |
| performance_schema |
| miezmiez |
| sys |
+--------------------+
rows in set (0.01 sec)
mysql> exit
Bye
All done!