Mysql an Grafana: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „=Datenbank anlegen= *mysql -u root -p =In Mysql= ==Datenbankl anlegen== *create database covid19; ==Tabellen anlegen== *use covid19; *create table statistik (d…“) |
|||
Zeile 3: | Zeile 3: | ||
=In Mysql= | =In Mysql= | ||
==Datenbankl anlegen== | ==Datenbankl anlegen== | ||
− | *create database covid19; | + | **create database covid19; |
==Tabellen anlegen== | ==Tabellen anlegen== | ||
− | *use covid19; | + | **use covid19; |
− | *create table statistik (datum date, best_faelle int, genesens int, verstorbene int); | + | **create table statistik (datum date, best_faelle int, genesens int, verstorbene int); |
=User anlegen und Rechte geben= | =User anlegen und Rechte geben= | ||
− | *create user 'covid-admin'@'localhost' identified by 'oimel'; | + | **create user 'covid-admin'@'localhost' identified by 'oimel'; |
− | *grant all privileges on covid19.* to 'covid-admin'@'localhost'; | + | **grant all privileges on covid19.* to 'covid-admin'@'localhost'; |
− | *flush privileges; | + | **flush privileges; |
Version vom 19. Juni 2020, 09:10 Uhr
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;