Mysql Tips: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| Zeile 4: | Zeile 4: | ||
=User Remote Zugriff gewähren= | =User Remote Zugriff gewähren= | ||
*grant all on covid19.* to 'covid-admin'@'10.81.1.1' identified by 'sysadm'; | *grant all on covid19.* to 'covid-admin'@'10.81.1.1' identified by 'sysadm'; | ||
| + | =Tabelle erstellen= | ||
| + | *create table testp (person varchar(32), year int, company varchar(32)); | ||
Aktuelle Version vom 24. Juni 2020, 12:14 Uhr
User anzeigen
- use mysql;
- select * from user;
User Remote Zugriff gewähren
- grant all on covid19.* to 'covid-admin'@'10.81.1.1' identified by 'sysadm';
Tabelle erstellen
- create table testp (person varchar(32), year int, company varchar(32));