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;