Sql injection database: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „=Datenbank anlegen= *create database sql_injections; =In die Datenbank wechseln= *use use sql_injections; =Tabelle anlegen= *create table users (id int(16), us…“) |
|||
| (2 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 2: | Zeile 2: | ||
*create database sql_injections; | *create database sql_injections; | ||
=In die Datenbank wechseln= | =In die Datenbank wechseln= | ||
| − | * | + | *use sql_injections; |
| + | |||
=Tabelle anlegen= | =Tabelle anlegen= | ||
*create table users (id int(16), username varchar(16), password varchar(16)); | *create table users (id int(16), username varchar(16), password varchar(16)); | ||
| + | =Tabelle füllen= | ||
| + | *insert into users values(1,"hans.will","geheim"); | ||
| + | *insert into users values(2,"rudi.burkart","secret"); | ||
| + | *insert into users values(3,"erwin.lehmann","weisniemand"); | ||
| + | =User anlegen und Rechte zuteilen= | ||
| + | *use mysql; | ||
| + | *create user 'xinux'@'localhost' identified by 'suxer'; | ||
| + | *grant all privileges on sql_injections.* to 'xinux'@'localhost' ; | ||
| + | *flush privileges; | ||
| + | *quit | ||
Aktuelle Version vom 2. Juni 2021, 14:34 Uhr
Datenbank anlegen
- create database sql_injections;
In die Datenbank wechseln
- use sql_injections;
Tabelle anlegen
- create table users (id int(16), username varchar(16), password varchar(16));
Tabelle füllen
- insert into users values(1,"hans.will","geheim");
- insert into users values(2,"rudi.burkart","secret");
- insert into users values(3,"erwin.lehmann","weisniemand");
User anlegen und Rechte zuteilen
- use mysql;
- create user 'xinux'@'localhost' identified by 'suxer';
- grant all privileges on sql_injections.* to 'xinux'@'localhost' ;
- flush privileges;
- quit