|
|
| Zeile 1: |
Zeile 1: |
| =MySQL= | | =MySQL= |
| ==Download== | | ==Install== |
| apt-get install mysql-server mysql-client | | apt-get install mysql-server mysql-client |
| ==Login== | | ==Login== |
| *Nachdem der MySQL Server installiert wurde, meldet man sich mit dem folgenden Befehl auf der Datenbank an.
| |
| mysql -u root -p | | mysql -u root -p |
| ==Status prüfen== | | ==Status prüfen== |
| *mit '''mysql> status''' wird der aktuelle Status von MySQL angezeigt. | | *'''mysql>''' status |
| <pre>
| | ==Datenbanken anzeigen== |
| mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper
| | *'''mysql>''' show databases; |
| | |
| Connection id: 10
| |
| Current database:
| |
| Current user: root@localhost
| |
| SSL: Not in use
| |
| Current pager: stdout
| |
| Using outfile: ''
| |
| Using delimiter: ;
| |
| Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)
| |
| Protocol version: 10
| |
| Connection: Localhost via UNIX socket
| |
| Server characterset: latin1
| |
| Db characterset: latin1
| |
| Client characterset: utf8
| |
| Conn. characterset: utf8
| |
| UNIX socket: /var/run/mysqld/mysqld.sock
| |
| Uptime: 2 hours 28 min 2 sec
| |
| | |
| Threads: 1 Questions: 12 Slow queries: 0 Opens: 107 Flush tables: 1 Open tables: 26 Queries per second avg: 0.001
| |
| </pre>
| |
| | |
| ==Erstellen einer Datenbank==
| |
| mysql> create database test;
| |
| Query OK, 1 row affected (0,00 sec)
| |
| ==Anzeigen der Datenbanken== | |
| <pre>
| |
| mysql> show databases; | |
| +--------------------+
| |
| | Database |
| |
| +--------------------+
| |
| | information_schema |
| |
| | mysql |
| |
| | performance_schema |
| |
| | sys |
| |
| | test |
| |
| +--------------------+
| |
| 5 rows in set (0,00 sec)
| |
| </pre>
| |
MySQL
Install
apt-get install mysql-server mysql-client
Login
mysql -u root -p
Status prüfen
Datenbanken anzeigen