Mysql an Grafana
Version vom 19. Juni 2020, 09:24 Uhr von Thomas.will (Diskussion | Beiträge) (→CSV Datei importieren)
Datenbank anlegen
- mysql -u root -p
In Mysql
Datenbankl anlegen
- create database covid19;
Tabellen anlegen
- use covid19;
- create table statistics (datum date, best_faelle int, genesene 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)
CSV Datei importieren
- load data local infile '/root/rki.csv' into table statistics fields terminated by ',';
- select * from statistics;
+------------+-------------+----------+-------------+ | datum | best_faelle | genesene | verstorbene | +------------+-------------+----------+-------------+ | 2020-03-04 | 262 | 0 | 0 | | 2020-03-05 | 400 | 0 | 0 | | 2020-03-06 | 639 | 0 | 0 | | 2020-03-07 | 795 | 0 | 0 | | 2020-03-08 | 902 | 0 | 0 | ... ... ...
Grafana
- Configuration
- Data Sources
- New Data Source
- Mysql
- New Data Source
- Data Sources