Mysql an Grafana

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;