Mysql an Grafana
Version vom 19. Juni 2020, 09:16 Uhr von Thomas.will (Diskussion | Beiträge)
Datenbank anlegen
- mysql -u root -p
In Mysql
Datenbankl anlegen
- create database covid19;
Tabellen anlegen
- use covid19;
- create table statistik (datum date, best_faelle int, genesens int, verstorbene int);
User anlegen und Rechte geben
- create user 'covid-admin'@'localhost' identified by 'oimel';
- grant all privileges on covid19.* to 'covid-admin'@'localhost';
- flush privileges;
Tabelle anzeigen
- desc statistik;
+-------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------+------+-----+---------+-------+ | datum | date | YES | | NULL | | | best_faelle | int(11) | YES | | NULL | | | genesens | int(11) | YES | | NULL | | | verstorbene | int(11) | YES | | NULL | | +-------------+---------+------+-----+---------+-------+ 4 rows in set (0.00 sec)